Working with multiple database I was always wondering if there's a way to simply transfer tables structures and data from one database to another.
Looking over the internet I found that using a database migration SQL script is often the best way to migrate a database. Then I found SQL Script Builder, with this small but yet powerful app I was able to connect to my data source using ODBC, a universal interface, extract data as SQL, and dump data to destination, like for example uploading the script on one website server.
Scripts can be made as MySql, MS SQL, Oracle, Pervasive and Postgres.
You can also export to Access mdb, xml and csv files !
I hope you will find this link useful : http://www.sqlscriptbuilder.com
Tom