Postgres Pro
Downloads
Home   >   mailing lists

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

From Dave Page
Subject Re: Miigration Wizard ignores not nulls & default values
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B825A189@mail.vale-housing.co.uk
Whole thread Raw
In response to Miigration Wizard ignores not nulls & default values  ("Roger Gordon" <Roger@emojo.com>)
List pgadmin-support
Tree view
 
-----Original Message-----
From: Roger Gordon [mailto:Roger@emojo.com]
Sent: 19 May 2003 10: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….

 

Hi Roger,

 

Did you have the 'Don't ignore NOT NULL' option checked when you migrated?

 

The default values are not migrated at all as you say (though they were years ago). Primarily this is because they tend to cause too many problems with syntax incompatibilities between DBMSs.

 

Regards, Dave.

pgadmin-support by date:

Previous
From: "Ermanno PREDONZAN"
Date:
Subject: MS-Access link
Next
From: "Dave Page"
Date:
Subject: Re: MS-Access link