Re: migrate from postgres to mysql - Mailing list pgsql-general

From Arguile
Subject Re: migrate from postgres to mysql
Date
Msg-id 1065125879.26645.108.camel@broadswd
Whole thread Raw
In response to migrate from postgres to mysql  ("Fabio Benavides Murillo" <fabio@novasitios.com>)
Responses Re: migrate from postgres to mysql
Re: migrate from postgres to mysql
List pgsql-general
On Thu, 2003-10-02 at 08:49, Fabio Benavides Murillo wrote:
> > Hello
> >
> > I have a problem, I want to migrate the data of a postgres' database to a
> > mysql's database, this because i need to move to a windows.

You might also want to explore running PostgreSQL on windows. Currently
you can use Cygwin to stably run the current version of Pg. There is
also a native windows port on the way, if it's for development uses you
might want to test the beta.

> > I tried making a postgres' backup using pg_dump, but this file doesn't
> have
> > the insert in Transac-sql.

Transact-SQL is actually Sybase's and MS SQL Server's dialect of SQL.


Perhaps you're referring to the use of COPY instead of INSERT
statements? If so see the help for pg_dump as you can have data dumped
as individual inserts (the -d and -D switches).

You'll probably have to do some editing of the dump by hand as well; to
change sequences to MySQL's auto_increment, remove any schema usages,
etc. I'm unaware of any automated tools as not many people migrate in
that direction ;).



pgsql-general by date:

Previous
From: "Rick Seeger"
Date:
Subject: Re: Can anyone recommend a good PostGres admin tool?
Next
From: Scott Cain
Date:
Subject: Re: migrate from postgres to mysql