Compare and Synchronize MS SQL Database Schemas
- Compare and synchronize MS SQL Server database schemas
- Visualize the differences between database schemas
- Generate intelligent synchronization scripts
- Automate schema synchronization with command-line utility
- Automatic mapping of (renamed) database objects
For many organizations, the size and complexity of their MS SQL database environments has increased significantly. Datanamic SchemaDiff for MS SQL provides the ability to compare and synchronize two MS SQL database schemas. After the comparison is performed, Datanamic SchemaDiff for MS SQL generates the synchronization script that can be used to update the destination database schema to match the source database.
With Datanamic SchemaDiff for MS SQL you can automatically compare and synchronize the schemas of MS SQL Server databases and avoid mistakes with deploying structure changes from one database to another database (for example: test environment to production environment).
It is a challenge to ensure that MS SQL Server database schemas are consistent across two different databases. When database structures change, DBAs often spend significant time creating complex SQL scripts, even though the update itself might be a simple one. Manual synchronization can be error prone because of object dependencies and the complexity of the database schemas. You need a solution that will automatically compare and identify the object differences between two MS SQL Server database schemas and then synchronize them.
Datanamic SchemaDiff for MS SQL enables you to compare and synchronize database schemas. The tool will give you the full picture of all database schema differences. Once your database schemas are compared, you can view the differences and generate the necessary synchronization script to update the destination database and make it identical to the source database.
Datanamic SchemaDiff for MS SQL simplifies database administration tasks and increases DBA productivity.
MS SQL Server Connectivity
- Direct access to MS SQL Server databases.
- Multiple MS SQL versions supported.
MS SQL 2000, 2005, 2008 and 2012 are supported.
- Cross database versions comparison.
You can for example compare (and synchronize) a MS SQL 2005 databases and a MS SQL 2008 database.
Database Schema Comparison
- Database schema to database schema comparison.
Connect to two MS SQL Server databases and compare the objects in those databases.
- SQL script to database schema comparison.
Connect to a MS SQL Server databases and select a SQL script representing a database and compare the objects in both sources.
- Schema mapping.
Mapping schemas enables you to compare database objects that belong to the same or different schemas.
- Intelligent object mapping.
Mapping is used to connect the objects to be compared. Mapping of database objects in source and destination database is done based on names. If no object with the same name was found, intelligent routines are used to find out if an object must be mapped to an object with another name. It detects renamed database objects.
- Compare all database object types. Compare tables, procedures, indexes, views, triggers, constraints etc.
- Generate HTML reports with database differences.
- Wide array of comparison options.
You can control what is compared and what is seen as a difference. Use the comparison options such as case insensitivity, ignore constraints and 30 other options. The comparison options let you tweak the way the comparison works.
- Synchronize complete database or selected objects.
You can select the database objects you want to synchronize.
- Intelligent alter script generation.
Generated script handles object dependencies and preserves data.
- Fine-tune the synchronization process with synchronization options.
You can ignore table elements or objects descriptions for example, for synchronization.
Presentation Of Object Differences
- Visual representation of differences.
A side-by-side, colour-coded comparison overview makes it easy to pinpoint at a glance similarities and differences between two database objects.
- Summary of differences between two databases.
The summary includes objects in source but not in destination (or vice versa), identical objects and the totals of selected objects. You can easily copy the summary to the clipboard.
- Object type filtering.
Filtering the comparison results enable you to limit the display of objects to certain types of database objects (for example, show only tables and/or views).
- Status filtering.
Filter the comparison results based on the status (identical, different, etc...) of the compared object.
Database Administration Automation
- Automated object comparison and synchronization.
A command line utility is included to automate your compare and synchronize process.
Save your comparison plan to a SchemaDiff project.
Datanamic SchemaDiff for MS SQL costs $ 299 for a single user license (EULA).
Upgrade Protection/Support is optional and costs 20% of the initial purchase price per year.
Operating System: Windows 10/8.1/8/7/Vista/XP
Memory: 1 GB minimum (2 GB recommended)
Hard Disk: At least 20 MB of free disk space
Databases: MS SQL Server 2000, 2005, 2008, 2012, 2014, 2016