Re: Migration from MSSQL to PGSQL

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@xxxxxxxxxxxxxx)
>
>
>  
I think there is an howto on techdocs.postgresql.org


regards ewald




---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html