> -----Original Message----- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] > Sent: 24 October 2003 16:23 > To: Dave Page; [EMAIL PROTECTED] > 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. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
