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,872
2
17
32

1

Red Gate also has Oracle and MySQL comparison tools. – David Atkinson Apr 20 '11 at 19:41
@David, I didn't know that... Thank you. – mevdiven Apr 20 '11 at 20:16

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

20,415
5
59
95

answered Apr 26 '11 at 21:57

ilhan

7,981
30
107
186

How do you track database changes?

3 Answers3