Skip site navigation (1) Skip section navigation (2)

Re: Migrating databases from MS SQL Server to PostgreSQL

From: "Sim Zacks" <sim(at)nospam(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Migrating databases from MS SQL Server to PostgreSQL
Date: 2004-11-16 11:18:00
Message-ID: cncnnt$2doh$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-odbc
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



In response to

pgsql-odbc by date

Next:From: Shachar ShemeshDate: 2004-11-16 13:42:42
Subject: Re: ODBC Driver stability
Previous:From: Rolf stvikDate: 2004-11-16 08:49:17
Subject: Re: Migrating databases from MS SQL Server to PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group