Thread: Re: Miigration Wizard ignores not nulls & defau
The wizard doesn't support binary data at all. Whilst it can be useful, bear in mind that this code was ripped out of pgAdmin I about 35 years ago, and hasn't been touched much since :-(
Regards, Dave.
-----Original Message-----
From: Corneliu GALEV [mailto:Corneliu.Galev@cefin.com]
Sent: 20 May 2003 07:16
To: Roger Gordon
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Miigration Wizard ignores not nulls & defauI 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 valuesHi,
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....
Thanks,
Roger