Hi
Mike,
Please
use the [EMAIL PROTECTED]
list for future support issues.
-----Original Message-----
From: Mike Glauser [mailto:[EMAIL PROTECTED]
Sent: 19 August 2003 21:57
To: [EMAIL PROTECTED]
Subject: A bit of a problem...I was migrating a fairly significant database from MS SQL to PostgreSQL and when it was all finished, it undid itself.I didn't say anything that I could use to figure out why.Is there any way to tell WHAT was invalid, or what it was trying to do at that point (apparently after finishing).
Yes, please set the log level to
SQL & Errors under Tools -> Options, and rerun the migration to create an
SQL log. Unfortunately this will slow down things somewhat, so if you can
do it with an exact copy of the table, just with fewer rows it would
probably be less painful.
Maybe a feature that would commit after the table is built, and after each index is built. At least this might have saved me a day's work and the attempt to find some other way to move my database to PostgreSQL.
You probably saw the per-table
commit option. Most people don't even use that, never mind a per-object commit
:-(
Regards,
Dave.