Re: Migration from MSSQL to PGSQL - Mailing list pgsql-novice

From Ewald Geschwinde
Subject Re: Migration from MSSQL to PGSQL
Date
Msg-id 3D3EDBDF.5060803@geschwinde.net
Whole thread Raw
In response to Migration from MSSQL to PGSQL  (Jeffrey Trueblood <jtrueblood@pilenet.com>)
List 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@postgresql.org)
>
>
>
>
I think there is an howto on techdocs.postgresql.org


regards ewald




pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Database Users and Permissions
Next
From: Josh Berkus
Date:
Subject: Re: Migration from MSSQL to PGSQL