Re: PostgreSQL -> MySQL...impossible?
It's not impossible, but actually pretty easy.
The first step is to recreate the Postgresql table in Mysql, you can do this by taking the create table DDL from Postgresql, making the changes to the field types and executing it on the Mysql server.
The next step is to use a product like PG Lightning Admin which can export data from Postgresql to Mysql (or any other database for that matter).
Check it out here:
http://www.amsoftwaredesign.com
There is also going to be a Lightning Admin for Mysql soon which will allow you export data from Mysql to PG.
Later,
Tony
Subject
Views
Written By
Posted
16837
July 15, 2005 06:52AM
8085
October 11, 2005 11:19AM
8109
December 20, 2005 11:32AM
11025
January 02, 2006 06:44PM
7562
February 14, 2006 11:12PM
7302
March 26, 2006 06:07PM
7889
February 16, 2006 05:00PM
6678
March 03, 2006 08:06PM
6706
March 27, 2006 10:29AM
8640
March 30, 2006 01:55AM
8475
April 09, 2006 10:42AM
6145
May 02, 2006 01:29AM
6125
May 02, 2006 01:42AM
5949
May 04, 2006 05:40AM
Re: PostgreSQL -> MySQL...impossible?
9585
August 04, 2006 08:47PM
6553
November 21, 2006 10:46AM
6128
November 26, 2006 11:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.