How do you track database changes?

Question

Is there any tool that can compare the development database and the public database?

If you want to compare content too, you can use the checksum function: http://dev.mysql.com/doc/refman/5.0/en/checksum-table.html — Capsule, Apr 20 '11 at 16:05
You may find these useful - http://stackoverflow.com/q/1607/569659 - http://stackoverflow.com/q/6371/569659 - http://stackoverflow.com/q/4952/569659 - http://stackoverflow.com/q/175451/569659 — mark-cs, Apr 20 '11 at 16:04

score 3 · Answer 1 · answered Apr 20 '11 at 16:03

Redgate software have a schema comparison tool called MySQL Compare, which I have used to great effect before. When we had an issue with our databases getting out of sync. It is in early access/beta so it is currently free.

Unfortunately it is Windows only and I have not tried it under Wine on linux.

score 0 · Answer 2 · answered Apr 20 '11 at 17:35

0

Redgate Software bundle has both data and schema compare. I've been using them happily without looking back.

PS: It is for SQL Server only though...

answered Apr 20 '11 at 17:35

mevdiven

1,902
2
17
33

1

Red Gate also has Oracle and MySQL comparison tools. – David Atkinson Apr 20 '11 at 19:41

score 0 · Accepted Answer · edited May 12 '11 at 14:29

0

I ended up using Navicat for MySQL.

edited May 12 '11 at 14:29

Treffynnon

21,365
6
65
98

answered Apr 26 '11 at 21:57

ilhan

8,700
35
117
201

How do you track database changes?

3 Answers3