Thread: pgAdmin3 MySQL to PostgreSQL converter?
Dear friends, I tested MySQL conversion tools and none of them really works. My test case was a Drupal MySQL database with 100 tables. A client is using MySQL and Drupal displays a bunch of red messages saying the database does not answer. This is not a server question. It is only that MySQL stops responding when the number of queries rises, which happens in a Drupal environment (a single page can send 200 queries). MySQL database are indeed very limited to small projects. You can only use MySQL when caching is on in Drupal. In a production environment, even with caching, you cannot trust a MySQL database during a stress. I had a look at the database and realized that the tables had duplicate entries although it carries unique indexes. I discovered that it is very common for unique entries in MySQL database to allow duplicates! Even during import, you can disable uniqueness verification. So I decided to migrate to PostgreSQL. Migrating a MySQL to PostgreSQL is not so easy because you need to tune by hand the resulting schema. PostgreSQL version of Drupal has custom types. And no converter seems (to my knowledge) to allow tuning types. It seems a reasonable approach to believe that pgAdmin3 would be a great converted if it could connect to a MySQL database, map MySQL types to PostgreSQL types and migrate database reading each entry. So my question is: do you plan to add a MySQL converted in pgAdmin3. This would be a great killer feature and probably requires much work ... Kind regards, Jean-Michel
Attachment
2009/12/8 Jean-Michel Pouré <jmpoure@free.fr>: > So my question is: do you plan to add a MySQL converted in pgAdmin3. No, not at present > This would be a great killer feature and probably requires much work ... Yes, it certainly would. Remember the Access Migration tool in pgAdmin I? It was the only part that I didn't rewrite for pgAdmin II because it was too much work. The other issue, is that as soon as we've done MySQL, there will be another email say 'but what about $OTHER_DBMS?' There are probably also licensing issues, with the MySQL connectors all being GPL... So, I think such a feature would need a strong, ongoing commitment from a developer who is interested in such tools, once the licencing issues are overcome. BTW; did you try the MySQL migration wizard available through StackBuilder (which comes with the one-click installers)? Were there problems with that? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
Le mardi 08 décembre 2009 à 08:44 +0000, Dave Page a écrit : > The other issue, is that as soon as we've done MySQL, there will be > another email say 'but what about $OTHER_DBMS?' Agreed. There is a need for a better import tool in pgAdmin, for sure. This is a very basic need. There should be python binding/connectors or abstraction layers available. I am not aware of licensing issues. > > BTW; did you try the MySQL migration wizard available through > StackBuilder (which comes with the one-click installers)? Were there > problems with that? Do you mean http://pgfoundry.org/projects/stackbuilder? Sorry I did not try using it as I use Debian packaging system or make custom installs. Where can I download your migration wizard, I will test it with great pleasure ? Kind regards, Jean-Michel
Attachment
On Tue, 2009-12-08 at 09:56 +0100, Jean-Michel Pouré wrote: > > Where can I download your migration wizard, It is in EDB website: http://www.enterprisedb.com/openDownloads.do?productId=407&redirectReason=true&productVersion=otherDownload If you are using CentOS 5/Fedora 11-12, it is also available in yum repository. Regards, -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachment
2009/12/8 Devrim GÜNDÜZ <devrim@gunduz.org>: > On Tue, 2009-12-08 at 09:56 +0100, Jean-Michel Pouré wrote: >> >> Where can I download your migration wizard, > > It is in EDB website: > > http://www.enterprisedb.com/openDownloads.do?productId=407&redirectReason=true&productVersion=otherDownload Yeah, I think that's the raw .jar files which may need a little massaging. The 32bit linux installer is at http://www.enterprisedb.com/getfile.jsp?fileid=670, or 64bit at http://www.enterprisedb.com/getfile.jsp?fileid=671 The installers should work standalone (ie. without and existing PG/Stackbuidler installation on your machine), but we haven't tested that. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com