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 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. 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 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. Link to comment https://forums.phpfreaks.com/topic/198353-two-databases-compare/#findComment-1040827 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.