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