DataRater Posted April 13, 2010 Share Posted April 13, 2010 Version 5 MySQL I have a development and production database and want to know what differences there are between the two i.e. table and columns. Is there a tool I can use to do this? Preferably a free one! Stephen Quote Link to comment https://forums.phpfreaks.com/topic/198353-two-databases-compare/ Share on other sites More sharing options...
Mchl Posted April 13, 2010 Share Posted April 13, 2010 Easiest, thouhg perhaps not the most convenient, way is to dump both database structures and use diff to compare dumps. Quote Link to comment https://forums.phpfreaks.com/topic/198353-two-databases-compare/#findComment-1040799 Share on other sites More sharing options...
DataRater Posted April 13, 2010 Author Share Posted April 13, 2010 Mchl, I'm using TextPad and the diff is not easy to understand. Have you any suggestions for a good diff to use? Are you thinking of using the UNIX diff? Stephen Quote Link to comment https://forums.phpfreaks.com/topic/198353-two-databases-compare/#findComment-1040821 Share on other sites More sharing options...
Mchl Posted April 13, 2010 Share Posted April 13, 2010 I usually use the diff viewer from tortoisesvn. Quote Link to comment https://forums.phpfreaks.com/topic/198353-two-databases-compare/#findComment-1040827 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.