Re: PostgreSQL -> MySQL...impossible? (Possible!!!)

[Rob Manning]

I have written a plugin to the SQuirreL SQL Client (www.squirrelsql.org/) called DBCopy (dbcopyplugin.sf.net).
You merely need to configure SQuirreL to connect to both databases.
Then you select the tables you want to copy from one database and paste them to the
schema of the other. It's not limited to PostgreSQL and MySQL - it handles some commercial
dbs well too. It will copy both the table structure and data, as well as constraints and indexes.

SQuirreL 2.1 final can be downloaded here:

http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=29193&release_id=381575

and DBCopy Plugin v0.20 for SQuirrel can be downloaded here:

http://sourceforge.net/project/showfiles.php?group_id=141843&package_id=155769&release_id=377275

You'll want to extract dbcopy-0.20.zip or dbcopy-0.20.tar.gz into the plugins directory of SQuirreL,
then see the usage tutorial here:

http://dbcopyplugin.sourceforge.net/index.php?page=usage

Rob Manning