dbForge Schema Compare for SQL Server

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Zoom [+]

Compare and synchronize structures of Microsoft SQL Server databases. dbForge Schema Compare for SQL Server lets you quickly and safely perform schema comparison and synchronization along with easy analysis of database structure differences. dbForge Schema Compare for SQL Server 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.

Our regular prices are shown below. Please logon to see your discounted prices.

dbForge Schema Compare for SQL Server V2.0

Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase.  All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed above including volume licensing and previous versions.

Our regular prices are shown above. Please logon to see your discounted prices.

What's new in dbForge Schema Compare for SQL Server V2.0?

• Support of native SQL Server backups - Users can use native SQL Server backups as a metadata source and compare them. It adds a new way to compare and update database structures without manual work.
• Database comparison and synchronization via command line - This is especially useful for users, who do repeated schema comparison and synchronization. It is enough to set a comparison once and the tool will prepare a file with required command line arguments - Source and Target connection strings, comparison options and settings. Users can schedule the launch time for the processes specified in the file and escape any waiting.
• Tracking database changes using version control systems - This prevents several developers from changing database objects simultaneously. Now it is easy to revert to earlier revisions and quickly identify who and when changed the objects. Comparison takes less time as schema snapshots are compared. dbForge Schema Compare uses two most popular version control systems — SVN and TFS.
• Generating comparison and synchronization reports - Now publishing differences between databases is automated and offered as clear and professionally looking reports.

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