Re: Migration from other database systems to PostgreSQL

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm@poure.com]
> Sent: 24 October 2003 16:23
> To: Dave Page; pgadmin-hackers@postgresql.org
> Subject: Re: [pgadmin-hackers] Migration from other database
> systems to PostgreSQL
>
> Le Vendredi 24 Octobre 2003 17:04, Dave Page a écrit :
> > I would like to allow some sort of source and target plugins with a
> > mapping/scriptable transformation service in between, perhaps using
> > embedded Python or Perl.
>
> I would call it Advanced advance :)
>
> How do you plan to connect to any database? Using which
> drivers? Is this why you mention ODBC? But ODBC has its own
> virtual  types. Is it reliable? And not all Oracle database
> have ODBC (you must pay for it). Just for information, can
> you describe in more details?

Database wise, yes, it would be like the pga2 Migration Wizard, allowing you to map incoming ODBC types to outgoing
types. 

> A good start might be to be able to read the dumps from
> Oracle, MySQL, DB2 and MsSQL. This would be a small
> revolution for PostgreSQL and would suit 90% needs of users.
> When this is achieved, and only then, you would go for more
> complex things.

This is a slightly different approach - mine is more like the old migration wizard, expanded with DTS style
transformations,and plugable data sources/targets. 

> I feel (but I am only an average programmer as you know) that
> a series of regexp would suffice.

For migrating from a dump maybe, but I want to import/export text, or script data transformations between existing
tableson the same or different databases and so on. 

Don't expect this anytime real soon though - it's one of those ideas I would love to implement but have no real reason
toactually do so.... 

Regards, Dave.