Re: MSSQL to PostgreSQL : Encoding problem

Arnaud Lesauvage wrote:
> Richard Huxton a écrit :
>>
>> Or go via MS-Access/Perl and ODBC/DBI perhaps?
>
> Yes, I think it would work. The problem is that the DB is too big for
> this king of export. Using DTS from MSSQL to export directly to
> PostgreSQL using psqlODBC Unicode Driver, I exported ~1000 rows per
> second in a 2-columns table with ~20M rows. That means several days just
> for this table, and I have bigger ones !

Well it's about 0.25 days, but if it's too long, it's too long.

>>> In DTS, I have 3 options to export a table as a text file : ANSI, OEM
>>> and UNICODE.
>>> I tried all these options (and I have three files, one for each).
>>
>> Well, what character-set is your database in?
>
>
> Collation in MSSQL is SQL_Latin1_General_CP1_Cl_AS.
> DTS documentation tells me that exporting in ANSI should export using
> the current codepage.
> According to my local setting, my codepage is Windows-1252.
> This file is not correctly read by COPY when using client_encoding of
> WIN1252 though...

Hmm. Odd that they don't agree on what WIN1252 is. I'm not sure how to
check the file and confirm one way or the other. Anyone else on the list
got an idea?

--
Richard Huxton
Archonet Ltd