Postgres Pro
Downloads
Home   >   mailing lists

Re: Miigration Wizard ignores not nulls & defau - Mailing list pgadmin-support

From Corneliu GALEV
Subject Re: Miigration Wizard ignores not nulls & defau
Date
Msg-id 4EA0BAB0806ED511A65300508BE774CA6B9330@cefinsrv
Whole thread Raw
List pgadmin-support
Tree view
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:

  1. NOT NULLs other than the primary key code migrate over as NULLs
  2. Default values are not migrated

I'm writing a script to fix these errors, but any advice would be most appreciated....

 

Thanks,

Roger

 

pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: pgAdmin 1.5.60 (BETA) Released
Next
From: "Dave Page"
Date:
Subject: Re: Miigration Wizard ignores not nulls & default values