 <p>We use <a href="http://www.sqlmanager.net/en/products/dbcomparer" rel="nofollow noreferrer">DB Comparer</a> from EMS - they have a large range of tools each specifically targeted for a particular platform (they support SQL Server, MySQL, Interbase/Firebird, PostgreSQL, Oracle etc).</p> <p>The program allows you to compare 2 databases, and generate scripts for going from each database schema to the other. It works out dependencies and each of the script components are shown in a sort-of visual way (it's really a glorified owner-drawer listbox, I think). You can run bits of the script against the relevant database, save scripts down to files, etc etc.</p> <p>We use it mostly for keeping our development SQL Server 2005 databases in line with each other.</p> <p>It's not free, but there is a trial version available and it's not particularly expensive given what it does.</p> <p>We have quite a number of EMS tools here and they're all pretty good - much prefer using their <a href="http://www.sqlmanager.net/en/products/mssql/manager" rel="nofollow noreferrer">SQL Manager for SQL Server</a> tool to the ones that come with SQL Server, or any of the commercial offerings we looked at a couple of years ago (Toad, Redgate, Embarcadero etc from memory, I think).</p>