Hello John, > I am new to MySQL. We have a development environment where we have > three systems > > 1) Developement Database on Machine A > 2) Test Databasae on Machine B > 3) Live Database on Machine C > > So we make changes to the Developement Database, then move them to test > then to live. My question is, is there a way of automatically migrating > the changes from Dev to Test, Test to Live ? > > I have worked with a DB which had an admin function wherein you could > connect two databases and it would run a comparison between the two > databases and produce a file of schema differences which you could > import to make the two DB schema's the same. Is there something like > this for MySQL ?
We have developed an IDE for database development that runs on Windows and it includes a schema compare utility, have a look here: www.upscene.com/documentation/dbw3/tools_schemacompare.htm The tool is called Database Workbench, see www.upscene.com I'm sorry to report that our webhosting service is in the middle of a hardware update at the moment and the website appears to be down, but it should be OK later this day. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
