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 tables on 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 to actually do so....

Regards, Dave.