I also noticed that varbinary fields are not migrated properly. I maped varbinary to bytea and fileds values are not migrated at all (I'm migrating from MSSQL7)
-----Original Message----- From: Roger Gordon [mailto:Roger@emojo.com] Sent: Monday, 19 May 2003 12:46 To: pgadmin-support@postgresql.org Subject: [pgadmin-support] Miigration Wizard ignores not nulls & default values
Hi,
Noticed 2 problems migrating from SQLServer 2000 using pgAdmin 1.4.12:
NOT NULLs other than the primary key code migrate over as NULLs
Default values are not migrated
I'm writing a script to fix these errors, but any advice would be most appreciated....