Re: Migration from other database systems to PostgreSQL

Поиск
Список
Период
Сортировка
От Jean-Michel POURE
Тема Re: Migration from other database systems to PostgreSQL
Дата
Msg-id 200310241723.21746.jm@poure.com
обсуждение исходный текст
Ответ на Re: Migration from other database systems to PostgreSQL  ("Dave Page" <dpage@vale-housing.co.uk>)
Список pgadmin-hackers
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?

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.

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

Cheers, Jean-Michel


В списке pgadmin-hackers по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: Migration from other database systems to PostgreSQL
Следующее
От: Andreas Pflug
Дата:
Сообщение: Re: Crash of the Option dialog