Re: Status of Migration Wizard ? - Mailing list pgadmin-support

From Dave Page
Subject Re: Status of Migration Wizard ?
Date
Msg-id AA30E7BCCA5C1D4E88A231900F8325C00C78@dogbert.vale-housing.co.uk
Whole thread Raw
In response to Status of Migration Wizard ?  (Didier Moens <Didier.Moens@dmb.rug.ac.be>)
List pgadmin-support

> -----Original Message-----
> From: Didier Moens [mailto:Didier.Moens@dmb001.rug.ac.be]
> Sent: 12 November 2001 12:40
> To: pgadmin-support@postgresql.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.

pgadmin-support by date:

Previous
From: Didier Moens
Date:
Subject: Re: Status of Migration Wizard ?
Next
From: Chris Lee
Date:
Subject: Too many postgresql process