Migration from MSSQL to PGSQL

From: Jeffrey Trueblood <jtrueblood(at)pilenet(dot)com>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Migration from MSSQL to PGSQL
Date: 2002-07-24 16:12:16
Message-ID: 5B486B6FC380D311822E009027CCB4C9A5428C@carbon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2002-07-24 16:15:23 Re: Database Users and Permissions
Previous Message Søren Neigaard 2002-07-24 14:24:31 Database Users and Permissions