Postgres Pro
Downloads
Home   >   mailing lists

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

From Dave Page
Subject Re: Miigration Wizard ignores not nulls & defau
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B825A19C@mail.vale-housing.co.uk
Whole thread Raw
List pgadmin-support
Tree view
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 & defau

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: Re: Miigration Wizard ignores not nulls & default values
Next
From: "Roman Fail"
Date:
Subject: Re: Miigration Wizard ignores not nulls & defau