CODEWITHSUNDEEP
mysqldatabasechange-tracking
fredrik
fredrik

Reputation: 13550

MySQL database change tracking

What tools are you using to track changes in your MySQL database?
Currently I'm in a project where we use a plain text-file (version controlled via SVN) in which we manually add SQL statements when making changes to the database.
Many of the changes magically disappears every now and then, and we are now looking for a better way to change track our database.

EDIT:
One thing that I forgot to mention, we are using stored procedures and functions, so it's not only the database structure that we want to track changes on / version controll.

Upvotes: 3

Views: 10869

Answers (4)

Petah
Petah

Reputation: 46060

Toad for MySQL has a great schema comparison tool

http://www.quest.com/toad-for-mysql/

Upvotes: 1

stepancheg
stepancheg

Reputation: 4276

mysql-diff compares tables, but not stored procedures yet.

Upvotes: 0

Hugues Van Landeghem
Hugues Van Landeghem

Reputation: 6808

I think you need something like this (I test it for Firebird and it works very well) : http://www.upscene.com/products.audit.index.php I thought there was a MySQL version but NO :(

for MySQL, I see just this : http://solutions.mysql.com/solutions/partner.php?partner=1532

But if it is just for development, I think that the answer given here is good

Upvotes: 0

anon
anon

Reputation:

There is a simple solution:

  • Make all changes to the database schema and static data via scripts
  • Version control the scripts

Upvotes: 8

Related Questions