Re: Transfering data from postgresql to MySQL

2004-10-21 Thread Patrick Hsieh()
now I managed to dump table schema with pg_dump. However, is there any schema converting tool available? I don't want to edit each table schema to make it mysql-compliant. Ideas? Pahud On Mon, 18 Oct 2004 12:23:41 +0200, Jochem van Dieten [EMAIL PROTECTED] wrote: On Mon, 18 Oct 2004

Re: Transfering data from postgresql to MySQL

2004-10-21 Thread Martijn Tonies
now I managed to dump table schema with pg_dump. However, is there any schema converting tool available? I don't want to edit each table schema to make it mysql-compliant. Download yourself a trial of Database Workbench at www.upscene.com It has a Schema Migrator tool that allows you to

Transfering data from postgresql to MySQL

2004-10-18 Thread Patrick Hsieh()
Hello list, I am planing to transfer data from postgresql to mysql. Is there any useful tools, scripts or utilities to achieve this? Any infomation is highly appreciated! --- Patrick Hsieh() [EMAIL PROTECTED] MSN: [EMAIL PROTECTED] | ICQ: 97133580 Skype: pahud_at_pahud.net | YIM: pahudnet

Re: Transfering data from postgresql to MySQL

2004-10-18 Thread Jochem van Dieten
On Mon, 18 Oct 2004 18:08:24 +0800, Patrick Hsieh wrote: I am planing to transfer data from postgresql to mysql. Is there any useful tools, scripts or utilities to achieve this? pg_dump First dump the schema, edit that until you have something MySQL understands. Then dump the data using

Re: Transfering data from postgresql to MySQL

2004-10-18 Thread Karam Chand
Hello, You can use SQLyog's ODBC Import Tool to import data from PgSQL to MySQL using PgSQL's ODBC driver. More information about SQLyog can be found at http://www.webyog.com Karam --- Jochem van Dieten [EMAIL PROTECTED] wrote: On Mon, 18 Oct 2004 18:08:24 +0800, 謝洪恩 Patrick Hsieh wrote: