2006/11/22, Arnaud Lesauvage <thewild@xxxxxxxxxxx>:
Tomi NA a écrit : > 2006/11/21, Arnaud Lesauvage <thewild@xxxxxxxxxxx>: >> 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. I think I'll go this way... No other choice, actually ! The MSSQL database is in SQL_Latin1_General_CP1_Cl_AS. I don't really understand what this is. It supports the euro symbol, so it is probably not pure LATIN1, right ?
I suppose you'd have to look at the latin1 codepage character table somewhere...I'm a UTF-8 guy so I'm not well suited to respond to the question. :) t.n.a.
