OT: Converting Data From PostGreSQL to MySQL

[Gilbert T. Gutierrez, Jr.]

I am not that familiar with PostGreSQL and made a mistake in selecting it
for this application.  I can, I am sure move the data.  The issue is the
time it will take me.  Someone that is familiar may be able to do this
quicker than me.  The app also has a way to export data and then re-import
it that I may end up using, I am just not comfortable that it will export
all data.

Gilbert

-----Original Message-----
From: plug-discuss-bounces at lists.plug.phoenix.az.us
[mailto:plug-discuss-bounces at lists.plug.phoenix.az.us] On Behalf Of George
Toft
Sent: Friday, August 04, 2006 3:00 PM
To: Main PLUG discussion list
Subject: Re: OT: Converting Data From PostGreSQL to MySQL

Shooting from the hip here . . .

MySQL has a dump facility that creates the SQL statements necessary to 
build the database and polupate it.  If PostGres has the same feature, 
it seels to me that you could dump/export PostGres and then execute the 
dump into MySQL.

George Toft, CISSP, MSIS
My IT Department
www.myITaz.com
480-544-1067

Confidential data protection experts for the financial industry.


Gilbert T. Gutierrez, Jr. wrote:
> Is there anyone out there that has a lot of familiarity with both
PostGreSQL
> and MySQL that I can contract to help me with migrating data between the 2
> databases?  I would like some references.
> 
> ------------------------------------
> Phoenix Internet
> Gilbert T. Gutierrez, Jr.
> Operations Manager
> Gilbert.G at phoenixinternet.net
> 2922 W CLARENDON AVE
> PHOENIX, AZ  85017
> tel: (602)234-0917x106
> fax: (602)234-0699
> mobile: (602)369-2603
> IM: phxintgilbert
> http://www.phoenixinternet.net
> ------------------------------------
> 
> 
> ---
> [ This E-mail was scanned for viruses by Phoenix Internet ]
> [ Phoenix Internet http://www.phoenixinternet.net ]
> 
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change  you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
> 
> 
---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change  you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
---
[ This E-mail was scanned for viruses by Phoenix Internet ]
[ Phoenix Internet http://www.phoenixinternet.net ]


---
[ This E-mail was scanned for viruses by Phoenix Internet ]
[ Phoenix Internet http://www.phoenixinternet.net ]