I'm using 8.2.3. I don't know which version of MySQL the faculty member has her database in.
I really appreciate all the helpful suggestions. This seems like a very interesting topic.
Carol
On Sep 4, 2008, at 3:42 PM, Alan Scott wrote:
What version of Postgres? We have 8.3 and have been using Migration Studio from Enterprise DB (which is part of the Advanced Server install). Also, with MySQL 5.0 and above they have some conversion tools that do come with the install to assist you.
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.