About transform SQL grammar from postgresql 8.0 to mysql 3.0

Поиск
Список
Период
Сортировка
От Emi Lu
Тема About transform SQL grammar from postgresql 8.0 to mysql 3.0
Дата
Msg-id 434BDB95.1090004@cs.concordia.ca
обсуждение исходный текст
Ответы Re: About transform SQL grammar from postgresql 8.0 to  (Sean Davis <sdavis2@mail.nih.gov>)
Список pgsql-general
Hello,

I know there is a script in perl can transform all sql commands in mysql
into the queries supported by postgreSQL.

Since we have not finished moving all data from mysql into postgresql,
we need dump around 60 tables from postgresql 8.0 to mysql 3.0 on a
daily basis.

So, I am looking for some existing scripts that can change postgresql
SQL grammar (E.g., filtering "set search_path") into the ones supported
by mysql 3.0?

Thanks a lot!
Emi



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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: PostgreSQL terminated abnormally
Следующее
От: Ludwig Isaac Lim
Дата:
Сообщение: \dD does not show check constraint for domain on version 8.0.4?