From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'Didier Moens'" <Didier(dot)Moens(at)dmb001(dot)rug(dot)ac(dot)be>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Status of Migration Wizard ? |
Date: | 2001-11-12 13:13:07 |
Message-ID: | AA30E7BCCA5C1D4E88A231900F8325C00C78@dogbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: Didier Moens [mailto:Didier(dot)Moens(at)dmb001(dot)rug(dot)ac(dot)be]
> Sent: 12 November 2001 12:40
> To: pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] Status of Migration Wizard ?
>
>
> Dave Page wrote:
>
>
> > 1) I wanted to redesign the Migration Wizard as it worked well for
> > Access, but not other DBs.
> > 2) The new design was based on the concept of building an object
> > hierarchy from the source database that could be modified
> in any way
> > required before building the target database. Data could then be
> > filtered across though user definable VB or JavaScripts
> (using the MS
> > scripting Engine).
>
>
> Intriguing. I suppose this could take care of the problem I'm
> having in
> PgAdmin I with regional settings (need to change from e.g. Dutch to
> English, in order to correctly import e.g. single precision fields).
>
>
> > Currently I have the bginnings of a pgAdmin II Migration Wizard
> > Plugin. It's not in CVS as it's not even remotely complete,
> but if you
> > (or anyone else) wants to take a look I'll happily make it
> available.
>
>
> Sure ; no objection being a beta-tester. After all, isn't
> everyone ? :)
>
> However, as I am on the brink of converting a crucial
> MSAccess project
> to PostgreSQL, and not being an ODBC nor a pgSQL wizard, I'm
> understandably hesitant to convert my data with a pre-beta (?) tool.
You misunderstand me I think. The code isn't even remotely beta, it barely
even gets a list of columns in a table from the source database yet. I
really have hit a total brick wall with this ODBC problem and don't have
time to look at it right now (I'm in the middle of a large migration of an
Informix database & IIS website to Linux).
If you still want to look at the code then the offer is still there of
course...
>
> > On my personal To-Do list, is a job to rip the old Migration Wizard
> > out of pgAdmin I and make it a standalone application. This
> would have
> > to be released under GPL as a number of people had a hand in that
> > code.
>
>
> So, I gather no "immediate" benefits are to be gathered from
> waiting for
> the PgAdminII Migration plug-in (as I've got this self-imposed 2001
> deadline for the conversion) ?
I doubt I'll even touch it this year. I'm not even sure my concept is
possible using ODBC :-(
> Actually, I wondered whether there would be any improvements wrt. the
> interaction with new pgSQL 7.2 features (ALTER TABLE ADD
> CONSTRAINT etc.).
>
It would be difficult to make direct comparisons as the new design concept
is so completely different.
In your case, I would suggest that you use pgAdmin I to migrate your data
(http://gborg.postgresql.org/project/pgadmin). I hope to solve this problem,
but I really don't know when I can right now :-(
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Lee | 2001-11-13 06:20:49 | Too many postgresql process |
Previous Message | Didier Moens | 2001-11-12 12:40:18 | Re: Status of Migration Wizard ? |