Mercurial and mysql

Question

I use Mercurial for version control of several projects. I have Mercurial installed on both my VPS and my local machine. I push the changes from the local machine to the remote server. Everything is fine.

However, I sometimes make changes to the database (mySql), and I need to update the database back and forth to synchronize remote and local versions (using phpmyAdmin).

Is there a solution for modifying changes in mysql, such as push changes in a remote repository?

Answer 1

Deploying a database is a pain. A common solution is to use a tool to view the source description of the database descriptor control (as a set of SQL scripts) and the target database and create / use a script to make them match.

Some tools that do this:

• dbdeploy (free)
• Ghost db
• Redgate SQL Compare
• Redgate MySQL Compare (free for non-profit)
• Visual Studio Database Projects (SSDT)

I am sure there are more of them.

Answer 2

Try the Database Project tools (and Schema / Data Comparer) in dbForge Studio for MySQL .