Re: Migrating databases from MS SQL Server to PostgreSQL

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

Will it help to raise the
"Max Varchar" or "Max LongVarchar" values
on Advanced Options for the Driver in the ODBC setup.

--
Rolf