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 server versions
• Capability to create schema snapshots and compare them with each other or with a live database
• Connection Manager for a full control of database connections

Database Structure Comparison

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

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
• Database synchronization via command line [New]
• Synchronization of database properties [New]
• Generating comparison and synchronization reports [New]
• Tracking database changes using a version control system [New]
• Table data verification after 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
• Capability 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