Re: Migration from MSSQL to PGSQL

From: Ewald Geschwinde <webmaster(at)geschwinde(dot)net>
To: Jeffrey Trueblood <jtrueblood(at)pilenet(dot)com>
Cc: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Migration from MSSQL to PGSQL
Date: 2002-07-24 16:54:55
Message-ID: 3D3EDBDF.5060803@geschwinde.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Jeffrey Trueblood wrote:

>Hello,
>I searched the archives, but could not find anything relating to my issue.
>
>I am migrating from Microsoft SQL 7.0 to PostgreSQL 7.2.1.
>I am using DTS to transfer the data.
>When trying to transfer a table, DTS fails with the following error, "Row
>value out of range".
>However, if I enter a single dummy record into the destination table, the
>transformation executes flawlessly.
>Has anyone else experienced this?
>Is there a way around this?
>
>
>Thanks in advance,
>Jeff
>
>P.S. I can't believe how great PGSQL is, and cannot wait to dump MSSQL all
>together.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
>
>
I think there is an howto on techdocs.postgresql.org

regards ewald

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2002-07-24 17:06:44 Re: Migration from MSSQL to PGSQL
Previous Message Bruno Wolff III 2002-07-24 16:15:23 Re: Database Users and Permissions