MySQL Forums
Forum List  »  MySQL Workbench

Applying difference to DB schema
Posted by: Leon de Beer
Date: February 18, 2009 01:58AM

Hi,

I have 2 database DEV and LIVE. We make all our schema changes to DEV and when do a release cycle we need to apply these change to LIVE. The only way I've figured out how to do this is to:

Dump the DEV schema
Dump the LIVE data
Drop the LIVE database
Create the LIVE database from the DEV schema
Restore the LIVE data

Obviously that's FAR from ideal as it's very dangerous and it breaks replication - every time! Ideally what I would like to do is:

exec [MAGICSCRIPT] which creates the relevant ALTER TABLE statements
Apply ALTER TABLE statement to LIVE database.

I did some research on this and I found some third party tools but they seem to cumbersome for what I'm trying to do. Is there a simpler way or is it time to dust of the bash scripting books and start coding?

Thanks

:Leon

Options: ReplyQuote


Subject
Views
Written By
Posted
Applying difference to DB schema
5830
February 18, 2009 01:58AM
3239
February 18, 2009 02:53AM
2943
February 18, 2009 03:54AM


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.