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(at)lavache(dot)com> wrote in message
news:e1471e4d(dot)0411160037(dot)33584de4(at)posting(dot)google(dot)com(dot)(dot)(dot)
> 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