Re: Transfering data from postgresql to MySQL
> 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 connect to ADO or ODBC datasources and convert them to MySQL. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transfering data from postgresql to MySQL
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 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 the -d option so you have full > inserts instead of the usual COPY syntax and feed the file to the > MySQL command line client. > > Jochem > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Patrick Hsieh(èææ) <[EMAIL PROTECTED]> MSN: [EMAIL PROTECTED] | ICQ: 97133580 Skype: pahud_at_pahud.net | YIM: pahudnet pub 1024D/203F7DF1 2001/12/25 Patrick Hsieh (Pahud) <[EMAIL PROTECTED]> http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x203F7DF1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transfering data from postgresql to MySQL
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: > > > > 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 the -d option > so you have full > inserts instead of the usual COPY syntax and feed > the file to the > MySQL command line client. > > Jochem > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transfering data from postgresql to MySQL
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 the -d option so you have full inserts instead of the usual COPY syntax and feed the file to the MySQL command line client. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
