It is a reliable, easy-to-use tool to compare and synchronize structures of Microsoft SQL Server databases.

This product is specially designed to help you quickly analyze database structure differences at a glance and propagate the changes to a required SQL Server escaping tedious manual work.

Tools automating simple tasks are no wonder now, but in reality you face non-standard situations followed by errors and hours of your precious time. dbForge Schema Compare is specially designed to assist you where you dig yourself in deep.

dbForge Schema Compare automatically tracks object dependencies, assuring they are properly ordered in the generated synchronization script and all interdependent objects are included. When you want to propagate only separate types of database structure changes, partial object synchronization is at your service.

Undoubtedly you can save data into tables with complicated structures, map one schema into several ones (one-to-many), view the synchronization script for any separate schema object, and many more...

Spend much time searching for numerous schema differences, sick of errors, and expecting no relief? Let dbForge Schema Compare do this chore for you! It not only streamlines all habitual tasks, but provides clear solutions for widely-spread deadlocks.

dbForge Schema Compare for SQL Server Features

SQL Server Connectivity

• Support of SQL server 2008, 2005 (including Express editions), and 2000 (including MSDE edition)
• Comparison and synchronization of databases on different SQL servers
• Connection Manager for a full control of database connections

Database Structure Comparison

• Accurate comparison with Schema Comparison wizard
• Comparison of all major SQL Server database objects
• Options for tables and script-based objects comparison
• Object filter to compare only required object types
• Custom schema mapping (one-to-many)

Analyzing Structure Differences and Synchronization

• Automatic grouping of objects by type
• Convenient filtering and sorting of comparison results
• Objects exclusion from synchronization
• Save and load comparison settings
• Detailed synchronization script plan
• View the synchronization script for any separate schema object
• Ability to backup Target database before synchronization
• Automatically compiled list of objects to add to synchronization based on object dependencies
• Options to customize the synchronization script output
• Warnings on possible data losses or errors during synchronization
• Asynchronous structure synchronization

SQL Execution and Data Management

• Execution of SQL scripts and queries
• Data editor with in-place filtering, grouping, and sorting options
• Paginal data access for large result sets
• Graphical card view for data editor
• Large objects (LOB) editor
• Text search in data editor
• Data printing
• Ability to postpone sending of data updates to the server (Cached updates mode)

Clear User Interface

• Customizable window layout
• Tool windows with 'auto-hide' and 'float' modes
• Multiple shortcut schemes with full shortcut customization
• Tabbed groups for documents
• Toolbars customization