Good ideas for synching schemas?
Posted by: amanda bee
Date: February 16, 2009 03:40PM

I've read through this thread:
http://forums.mysql.com/read.php?125,218526,227313

and I'm wondering if there are more good ideas. I, too, have a LAMP project that I want to be able to distribute updates to. If I make changes to one MySQL structure, I want to periodically sort out what has changed and migrate those changes to other databases.

So far I've handled it by dumping both structures, diffing them and then hand-writing "alter" statements to make up the difference. I feel like there must be a better way to automate this, though.

Options: ReplyQuote


Subject
Written By
Posted
Good ideas for synching schemas?
February 16, 2009 03:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.