From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Roger Gordon" <Roger(at)emojo(dot)com>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Miigration Wizard ignores not nulls & default values |
Date: | 2003-05-20 09:33:29 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B825A189@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
-----Original Message-----
From: Roger Gordon [mailto:Roger(at)emojo(dot)com]
Sent: 19 May 2003 10:46
To: pgadmin-support(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-05-20 09:51:28 | Re: A question |
Previous Message | Dave Page | 2003-05-20 07:08:20 | Re: ENCODING (Unicode) |