From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "DenBaguse MasRodjie" <roji(at)mail15(dot)com>, <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Convert database |
Date: | 2003-10-03 09:47:15 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B844B744@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi
pgAdmin II has a migration wizard (a seperate download) that should be
able to help you with this. Note that you will need MyODBC 2.50.19 -
other versions often crash. http://www.pgadmin.org/pgadmin2
Yes, PostgreSQL has subselects, and in my experience they are very fast
- I use them quite regularly.
Regards, Dave.
-----Original Message-----
From: DenBaguse MasRodjie [mailto:roji(at)mail15(dot)com]
Sent: 03 October 2003 10:32
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] Convert database
How to convert from MySQL to PostgreSQL.
I tried using DBTools, but to slowly. Converting 1 row taken
around 0.25 second!!!!
Because i have database over 100MB on MySQL. Maybe over 3 days
non-stop to converting.
Is there another way? I'm tried to using my2pg and mysql2pgsql.
But error occured.
I want to migrate to PostgreSQL 'cause i have a problem on
MySQL.'
MySQL doesn't support sub select on stable version (4.0.14) and
too slow sub select query on alpha version (4.1.0).
Is PostgreSQL support that features? How fast it can execute?
Thank's
Roji
From | Date | Subject | |
---|---|---|---|
Next Message | Amanjit Gill | 2003-10-03 12:20:18 | Re: FUD!! ODBC will not be supported by Microsoft in the future |
Previous Message | DenBaguse MasRodjie | 2003-10-03 09:31:45 | Convert database |