Skip site navigation (1) Skip section navigation (2)

Re: Database Conversion

From: "Hajek, Nick" <Nick(dot)Hajek(at)Vishay(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database Conversion
Date: 2008-09-04 15:22:52
Message-ID: AFD16ED07E37C64D963DA24840AA31F2043747AD@EVSCO01.na.vishayint.com (view raw or flat)
Thread:
Lists: pgsql-admin
> 
> Hello, All,
> 
> I have a new faculty member who has a large database that is 
> in MySQL.  We don't support MySQL so the database needs to be 
> ported to PostgreSQL.  Her GA, who know MySQL, says that he 
> has a query that he will run that will put the data into 
> postgres.  I thought that the data would have to be output to 
> a text file and then copied into postgres.  I don't know 
> MySQL.  I've done a conversion from Oracle and this is how I 
> did it.  Is he correct that he can put the data into a 
> postgres database by running a MySQL query?  It doesn't sound 
> possible to me.
> 
> Carol
> 

You could possibly do it in a single operation using MS Access if you
have an ODBC connection to each database.  If however the dataset is
large, I wouldn't recommend it.  I have a number of MySQL and PostgreSQL
dbs and I either dump sql and then import or use PHP scripts when moving
between the two.

Nick  

In response to

Responses

pgsql-admin by date

Next:From: Christian LarsenDate: 2008-09-04 16:06:09
Subject: Help!
Previous:From: Carol WalterDate: 2008-09-04 14:50:43
Subject: Re: Database Conversion

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group