| From: | "Tomi NA" <hefest(at)gmail(dot)com> |
|---|---|
| To: | "Arnaud Lesauvage" <thewild(at)freesurf(dot)fr> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: MSSQL to PostgreSQL : Encoding problem |
| Date: | 2006-11-22 10:30:45 |
| Message-ID: | d487eb8e0611220230v65326938k22d14f99354edba1@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2006/11/21, Arnaud Lesauvage <thewild(at)freesurf(dot)fr>:
> Hi list !
>
> I already posted this as "COPY FROM encoding error", but I have
> been doing some more tests since then.
>
> I'm trying to export data from MS SQL Server to PostgreSQL.
> The tables are quite big (>20M rows), so a CSV export and a "COPY
> FROM3 import seems to be the only reasonable solution.
I believe you might have more luck working without files altogether.
Use an ETL tool like kettle or even DTS with the pgsql ODBC driver.
That's exactly what those tools are for.
You still have to get the encodings right, though.
I suggest unicode for pgsql, but only you know how the MSSQL database
is encoded.
t.n.a.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arnaud Lesauvage | 2006-11-22 10:34:18 | Re: MSSQL to PostgreSQL : Encoding problem |
| Previous Message | Arnaud Lesauvage | 2006-11-22 10:02:07 | Re: MSSQL to PostgreSQL : Encoding problem |