Well, my database server lives on a Solaris 10 box. I'm running
PosgreSQL 8.2.3. The database that is being converted from MySQL is
currently on a Windows machine. So far it seems that every solution
involves an interim step or two. I think he was alluding to just
running a query.
Carol
On Sep 4, 2008, at 10:33 AM, Ben Kim wrote:
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.
I don't think mysql has anything that exports data into postgresql.
Unless he is talking about the likes of DTS/SSIS or perl DBI, or
other tools. Or the tables are simple and he thinks he can
ingeniously craft queries and run them through pipes eventually to
psql. DDL will be more difficult.
Regards,
Ben
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
