Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
|
I'm in a slight situation, although not that bad as someone is willing to work through the differences, but I have two MySQL database, one a live DB and the other a testing DB.
The test DB was originally a mimic of the live DB and has undergone a lot of changes to tables, views, some tables added, some modified etc.
Not all of the SQL updates have been written down, I would estimate 70% have been.
Ive trialled a couple of pieces of software that supposedly sync's the differences between two DBs, but not had much luck with them, they've not always listed all differences between the two.
Has anyone used anything like this?
|
VrsTurbo
Premium Member
Registered: 8th Jun 10
User status: Offline
|
Don't know if redgate does MySQL it does mssql
|
Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
|
I looked at redgate, they do offer a MySQL version, but was one of the ones I couldn't get on with.
DBForge seems to be doing the trick so far.
Compared all schemas so far, merged fine, now comparing data.
|
Dom
Member
Registered: 13th Sep 03
User status: Offline
|
Red Gate is the obvious; although there is Toad (iirc it's by Dell) and Nob Hill which iirc allow you to compare MySQL DBs.
Quick Google - http://stackoverflow.com/questions/225772/compare-two-mysql-databases
[Edited on 18-03-2013 by Dom]
|
Chris
Premium Member
Registered: 21st Sep 99
User status: Offline
|
Do you want to sync from live to dev, could you not just snapshot live to make a new dev.
Navicat is what i use
http://www.navicat.com/manual/online_manual/en/navicat/win_manual/DataSync.html
|
