would be more than 2 hours) ;
- pgAdminII 1.4.0 took approx. 19 minutes for tables and indexes, and
another 2 minutes for the foreign keys, totalling 21 minutes.
I could test 1.4.1 and 1.4.2, if you'd like.
Regards,
Didier
--
Didier Moens
-
RUG/VIB - Dept. Molecular Biomedical Res
subjobs3
Creating Foreign Key: budgetssubjobs3
Migration finished at: 24/12/2002 0:20:16, taking -77438,65 seconds.
3. The 'default values' of my Access2K fields do not get migrated : is
this a bug or a missing feature ?
Kind regards,
Didier
--
Didier Moens
-
RUG/VIB - Dept. Molecular
ecuting query [15] in psql yields :
template1=# SELECT datlastsysoid FROM pg_database WHERE datname =
'template1';
datlastsysoid
---
16974
(1 row)
HTH.
This is a major PITA, as I expected to migrate my Access2000 database to
PostgreSQL 7.3. :-/
Kind regards,
Di
Could this be due to an update to MSDAC 2.7 ?
Kind regards,
Didier Moens (getting quite desperate)
-
RUG/VIB - Dept. Molecular Biomedical Research - Core IT
tel ++32(9)2645309 fax ++32(9)2645348
http://www.dmb.rug.ac.be
ious]
6. [Next]
7. [Migrate db]
8. Create Columns as 'NOT NULL' where applicable
9. Create Indexes on Migrated Tables
10. Create Primary Keys on Migrated Tables
11. Password
12. Username
13. .mdb File
14. [...]
Correct order :
1-13-14-12-11-8-9-10-3-2-4-5-6-7
Regards,
Didier Moens
-
RU
(as per the "MS Access Workgroup Administrator",
wrkgadm.exe).
Thanks for a great piece of software.
Kind regards,
Didier Moens
-
RUG/VIB - Dept. Molecular Biology - Core IT
tel ++32(9)2645309 fax ++32(9)2645348
http://www.dmb.rug.ac.be
Dave Page wrote:
>
>>-Original Message-
>>From: Didier Moens [mailto:[EMAIL PROTECTED]]
>>Sent: 12 November 2001 12:40
>>To: [EMAIL PROTECTED]
>>Subject: Re: [pgadmin-support] Status of Migration Wizard ?
[migrating MS-Access data in pgAdmin I/II]
gAdminII Migration plug-in (as I've got this self-imposed 2001
deadline for the conversion) ?
Actually, I wondered whether there would be any improvements wrt. the
interaction with new pgSQL 7.2 features (ALTER TABLE ADD CONSTRAINT etc.).
Kind regards,
Didier Moens
-
RUG/V
release cycle :
- are there any (planned) improvements wrt the MW in PgAdmin 7.1 ?
- any improvements wrt PostgreSQL 7.2 ?
- is it possible to lift a prerelease out of the CVS ?
Congrats with an otherwise very nice tool.
Sincerely,
Didier Moens
-
RUG/VIB - Dept. Molecular Biology - Core
