+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: A MySQL table definition diff tool? (/showthread.php?tid=7323)
A MySQL table definition diff tool? - El Forum - 04-03-2008
[eluser]Daniel H[/eluser]
Guys -
OT from CodeIgniter here, but can anyone think of a tool that compares the definition of two MySQL databases and generate the appropriate MySQL statements to amend the tables of the 'target' database while leaving the data untouched?
Any ideas?
Thanks,
Dan.
A MySQL table definition diff tool? - El Forum - 04-03-2008
[eluser]Sean Murphy[/eluser]
Looks like this will do what you want: http://www.mysqldiff.org/
Also, there's the perl route: http://www.adamspiers.org/computing/mysqldiff/
A MySQL table definition diff tool? - El Forum - 04-25-2008
[eluser]Daniel H[/eluser]
This is a great help thanks. I'm going to experiment with Navicat's sync functionality first and then move onto this if it doesn't perform.