RE: OT: Converting Data From PostGreSQL to MySQL

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@lists.plug.phoenix.az.us
[mailto:plug-discuss-bounces@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@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@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@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 ]

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss