How to manage db structure evolution ?
Posted by: Jack First
Date: March 10, 2005 06:40AM

I'm not talking about version of the MySql database, but about my customers database structure version.

I need to set a label (version number) on their db to be able to follow the evolution. The next time my customer ask me for an upgrade of my soft, I will have to execute scripts to upgrade its database structure according to the evolution of my soft.

My questions are :

1. Is it possible to set a label (version number) on a MySql database structure ?
2. Is it possible to compare 2 MySql databases architecture in order to generate scripts to upgrade from one version to the next one ?

I'm still in testing different databases and those 2 points are the most important to be able to manage in the same time the evolutioin of the database structure and the soft.

Thanks a lot in advance.

Jack

Options: ReplyQuote


Subject
Written By
Posted
How to manage db structure evolution ?
March 10, 2005 06:40AM


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.