Compare Microsoft SQL Server Databases
Kentico Compare SQL allows you to easily compare the schema of MSSQL databases and see the differences. It compares:
- table definitions
- views
- stored procedures
- functions
It helps you in situations when you need to:
- compare the development and production database structure
- troubleshoot errors in the production environment that might be caused by database incompatibility
- check if your database creation script creates the same database as the original
- make sure that your upgrade procedure modifies the database correctly.
Kentico Compare SQL works with:
- Microsoft SQL Server 2000
- MSDE 2000
- Microsoft SQL Server 2005
- Microsoft SQL Server 2005 Express Edition
How it works:
- You specify the source and target databases.
- Kentico Compare SQL reads the structure of both databases.
- You can optionally store the structure on the disk for future usage.
- The program displays the differences and shows them in the form of creation script.
