From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: MS-server <-> Ppostgresql |
Date: | 2002-11-22 08:11:05 |
Message-ID: | 3DDDE699.7060507@paradise.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Francois Sauterey wrote:
> Apology for my so poop english... and my cross-postage.
>
> I plan to extract/copy about 120.000 lines from a MS SQL 7 server
> database (on a NT machione) to a postresql database on a Linux machine
> (debian/woody).
>
> But what a pity : I obtain (after so many tests, so many compilation
> with so many different options) a copy of about 1200 lines/minute ;~{
>
> And horror, I plan to make the same thing whith a 3.000.000 lines
> database.
>
> Any idea ?
> Best regards
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
The fastest way is :
i) write the table data from MS-SQL to a file
ii) use COPY to put the data into Postgresql from the file
if you do this then 3x106 rows should be < 7 minute operation !
regards
Mark
From | Date | Subject | |
---|---|---|---|
Next Message | Hans-Jürgen Schönig | 2002-11-22 08:16:16 | Re: Question about DEADLOCK |
Previous Message | Henry Pedask | 2002-11-22 08:04:51 | Re: PostgreSQL compilation with custom table name |