From: | Arguile <arguile(at)lucentstudios(dot)com> |
---|---|
To: | Fabio Benavides Murillo <fabio(at)novasitios(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: migrate from postgres to mysql |
Date: | 2003-10-02 20:17:57 |
Message-ID: | 1065125879.26645.108.camel@broadswd |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 ;).
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Cain | 2003-10-02 20:31:41 | Re: migrate from postgres to mysql |
Previous Message | Bruno Wolff III | 2003-10-02 19:37:39 | Re: pg_dump integrity question |