<p>My company has a number of relatively small Access databases (2-5MB) that control our user assisted design tools.  Naturally these databases evolve over time as data bugs are found and fixed and as the schema changes to support new features in the tools.  Can anyone recommend a database diff tool to compare both the data and schema from one version of the database to the next?  Any suggestions will be appreciated: free, open source, or commercial.</p>

[{'answer_id': 28376, 'author': 'Karim', 'author_id': 2494, 'author_profile': 'https://Stackoverflow.com/users/2494', 'pm_score': 0, 'selected': False, 'text': '<p>We never actually purchased it as we ended up using SQL Server 2005, but DBDiff seemed to do the trick: <a href="http://www.dkgas.com/downdbdiff.cgi" rel="nofollow noreferrer">http://www.dkgas.com/downdbdiff.cgi</a></p>\n\n<p>It works with any ODBC compatible DB.</p>\n'}, {'answer_id': 28449, 'author': 'Ryan Eastabrook', 'author_id': 105, 'author_profile': 'https://Stackoverflow.com/users/105', 'pm_score': 1, 'selected': False, 'text': "<p>I use ApexSQL Diff.  It is an excellent tool for doing just what you're describing...compare schema, compare data, generate change scripts.  It not free, but it works well.</p>\n\n<p><em>NOTE: ApexSQL Diff only works with SQL Server.</em></p>\n"}, {'answer_id': 28466, 'author': 'Marius', 'author_id': 1008, 'author_profile': 'https://Stackoverflow.com/users/1008', 'pm_score': 0, 'selected': False, 'text': '<p>I\'ve used <a href="http://www.fmsinc.com/MicrosoftAccess/DatabaseCompare.html" rel="nofollow noreferrer">Total Access Detective</a> in the past and it did the trick. It\'s a while ago though so you might want to investigate first...</p>\n'}, {'answer_id': 101026, 'author': 'Vitor Silva', 'author_id': 1842864, 'author_profile': 'https://Stackoverflow.com/users/1842864', 'pm_score': 4, 'selected': True, 'text': '<p>I use Red Gate Sql Compare for comparing schemas. It also has an interesting feature that allows you to save a snapshot of the schema which you can then use in later diffs. for example compare the schema of today with the schema of a month ago.</p>\n'}, {'answer_id': 1248413, 'author': 'edosoft', 'author_id': 6399, 'author_profile': 'https://Stackoverflow.com/users/6399', 'pm_score': 0, 'selected': False, 'text': '<p>If you\'re looking for a free alternative to Red Gate\'s most excellent SQL Compare, you might want to check SQLDBDigg made by <a href="http://www.sqldbtools.com/" rel="nofollow noreferrer">SQLDBTools</a>. It\'s what I used until I caved and bought SQL Compare.</p>\n'}, {'answer_id': 1248420, 'author': 'Darryl Hein', 'author_id': 5441, 'author_profile': 'https://Stackoverflow.com/users/5441', 'pm_score': 0, 'selected': False, 'text': '<p>It\'s not a perfect solution, but I often export both databases as txt/SQL files and then use a diff program, such as the one that comes with <a href="http://tortoisesvn.tigris.org" rel="nofollow noreferrer">TortoiseSVN</a>. You can then see all of the differences. It doesn\'t automatically create the SQL though to sync the dbs.</p>\n'}, {'answer_id': 4519006, 'author': 'honzajde', 'author_id': 271996, 'author_profile': 'https://Stackoverflow.com/users/271996', 'pm_score': 0, 'selected': False, 'text': '<p><a href="http://www.diffkit.org" rel="nofollow">http://www.diffkit.org</a></p>\n\n<p>Features</p>\n\n<p>High performance, for large datasets (+10MM rows).</p>\n\n<p>Very low memory overhead, even on very large datasets.</p>\n\n<p>High quality-- comprehensive embedded regression test suite for the application/framework.</p>\n\n<p>Java run everywhere (tm)\u2009—\u2009Linux, Solaris, OS X, Windows, etc.</p>\n\n<p>Cross database-- Oracle, MySQL, DB2, and any JDBC datasource.</p>\n\n<p>Command-line driven; no GUI needed; can run in headless environments.</p>\n\n<p>XML configuration file driven.</p>\n\n<p>Free Open Source Software.</p>\n\n<p>Apache License, Version 2.0.</p>\n\n<p>Clean Object Oriented Design make extension easy.</p>\n\n<p>Easily embeddable as a Java library (jar).</p>\n'}]
['https://Stackoverflow.com/questions/28363', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/1254/']