Hi,
Have you checked out our tool "Database Workbench" yet? It
includes a Schema Compare tool that generates a script.
See www.upscene.com
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
I have a two databases, one in a production environment (let's call it
db_prod) and the other in a testing environments (Let's call it db_test).
What is the best way to synchronize the database schemas? db_test has had a
few indexes and constraints added to several tables and I need to generate a
MySQL script to apply these changes to db_prod. So basically I want to dump
the schemas of the two database, compare, and generate the necessary script
to apply to db_prod.
Thanks,
Randall Price
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org