Migration from MSSQL to PGSQL - Mailing list pgsql-novice

From Jeffrey Trueblood
Subject Migration from MSSQL to PGSQL
Date
Msg-id 5B486B6FC380D311822E009027CCB4C9A5428C@carbon
Whole thread Raw
Responses Re: Migration from MSSQL to PGSQL
List pgsql-novice
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.


pgsql-novice by date:

Previous
From: Søren Neigaard
Date:
Subject: Database Users and Permissions
Next
From: Bruno Wolff III
Date:
Subject: Re: Database Users and Permissions