D-softs DB Compare
Database Comparison Utility
Database design is all about consistency. That's the polite way of saying "repetitious duplication of database structure objects", but really, when you think about it, the database mavens who are really good at what they do, really good at cranking out consistent database structures - well, their databases don't fail.
You've got to keep your records straight. You've got to be sure that the brilliant feature you just implemented in the test database made it through to the production database. Conversely, you also need to know, without a shred of doubt, that the horribly bad idea that you just caught in test is scrubbed out of the production database.
Enter DB Compare. It's your new friend, as in the kind of friend who'll compare your databases and point out every difference between your tables, views, stored procedures, and any other database object. DB Compare is such a good friend that, not only will it point out these differences, it'll sync your databases, too. Consistency!
DB Compare features an intuitive Ribbon style menu bar that lets you easily access the most commonly used functions of the program. Application buttons showcase brightly colored icons that clearly indicate their function - compare databases, sync databases, and filters to show only differences, or to show everything. Inconsistencies in your database structures are highlighted for easy reference. Using the Object Type drop-down menu, you can check and uncheck types of database objects to perform targeted comparisons.
DB Compare is a reliable tool for any database designer wanting to automate the process of ensuring consistency across multiple databases.
Promotion Written by Derek Lee