> 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
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
t; 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
> unders
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
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
Hi Jani and Owen,
Owen if you are dumping the data using pg_dump, I think I may be
able to help. First suggestion is to dump the data and the data
schema separetly. use,
for schema: pg_dump -sxnc -f/tmp/schema.dump databasename
for data: pg_dump -qxnd -f/tmp/data.dump databasename
The data
Hi,
[EMAIL PROTECTED] writes:
> To whom ever can help:
>
> I have a database dumped from PostgreSQL to a text file , is there any
> method used to convert this to MySQL?
Yes, please use mysqlimport. See mysqlimport --help for information,
more detailed information can be found from the MyS
To whom ever can help:
I have a database dumped from PostgreSQL to a text file , is there any
method used to convert this to MySQL?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
