Postgres Pro
Downloads
Home   >   mailing lists

Re: Importing directly from BCP files - Mailing list pgsql-general

From Tim Uckun
Subject Re: Importing directly from BCP files
Date
Msg-id CAGuHJrN8MEBFQF4-P7RVUu+FAoCfNN-xYo7Du4dcbHYJSAp3Dw@mail.gmail.com
Whole thread Raw
In response to Re: Importing directly from BCP files  (S McGraw <smcg4191@mtneva.com>)
Responses Re: Importing directly from BCP files  (S McGraw <smcg4191@mtneva.com>)
List pgsql-general
Tree view

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?

pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: Re: Importing directly from BCP files
Next
From: Albe Laurenz
Date:
Subject: Re: can postgres run well on NFS mounted partitions?