From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | <jm(at)poure(dot)com>, <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: Migration from other database systems to PostgreSQL |
Date: | 2003-10-24 15:44:44 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B84C5C55@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm(at)poure(dot)com]
> Sent: 24 October 2003 16:23
> To: Dave Page; pgadmin-hackers(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-10-24 15:46:02 | Re: Migration from other database systems to PostgreSQL |
Previous Message | Andreas Pflug | 2003-10-24 15:34:11 | Re: Migration from other database systems to PostgreSQL |