Re: Migrating databases from MS SQL Server to PostgreSQL

One of the default values in the ODBC driver is "Text as LongVarChar" you
want to remove that check mark.

"Doobie" <doobie@lavache.com> wrote in message
news:e1471e4d.0411160037.33584de4@posting.google.com...
> Hi,
>
> I'm trying to migrate one of our MS SQL databases to Postgre, but have
> encountered a little problem. I thought that the best way to do it was
> to use Postgre ODBC drivers to transfer data from SQL Server from a
> DTS. The only tables that I can't transfer have some columns of text
> type. I can't change it to varchar, because some fields can have more
> than 8040 characters (SQL Server's limit). When executing the DTS,
> I've got the following error : "Data for source column 9 is too large
> for the specified buffer size". Column 9 is the first column with text
> type.
> Do you have an idea on how I could avoid this, or another way to
> import data ? I've also tried to export my tables in text format and
> import with postgre's COPY, but some fields have carriage return
> included (for web pages) wich doesn't make it easy.
>
> Thanks,
> Doobie