Re: Importing directly from BCP files

On 11/15/2015 11:52 PM, Tim Uckun wrote:
> > I moved a database from MS Sql Server 2000 to Postgresql a few years
> > ago via BCP files. I used a Python script to do some fixup on the
> > BCP files to make them importable as CSV files into Postgresql. I
> > don't know if quirks I ran into are still an issue with newer versions
> > of Sql Server but for what it's worth, here are the comments from that
> > script:
>
> Do you rember what the encoding of the files was by any chance?

I don't but the machine they were exported from would have been using
either the regular English/US locale or CP-932 (Japanese).

Looking at the extract script, it seems the bcp command used to extract
them used -c option, eg:

bcp sw.dbo.swkwt out data\swkwt.tmp -c -U sa -P ****** -S NARA\SQLEXPRESS