According to the GA, the database has 1,000,000 rows. I hesitate to
pass that along because I don't know what that means. It strikes me
as an odd way to talk about a relational database. Normally, a
relational database has more than one table, so how is a "database"
having a million rows relevant. There are other databases in other
research projects, that have main tables that has well more than a
million records, so I don't know if this is considered large or not.
I thank you, all, for your answers.
Carol
On Sep 4, 2008, at 12:27 PM, Scott Marlowe wrote:
On Thu, Sep 4, 2008 at 9:22 AM, Hajek, Nick <Nick.Hajek@xxxxxxxxxx>
wrote:
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.
Also, if you can spare the afternoon to learn it, sed is an awesome
tool for ETL. I've used it for migrating stuff from oracle to pgsql
and mangling input data to work.
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
