dbForge Schema Compare for SQL Server Features
This page provides a comprehensive listing of features available in dbForge Schema
Compare for SQL Server. For a list of dbForge Schema Compare for SQL Server 3.0
new features see What's New in 3.0.
What SQL Server versions are supported?
- SQL Server 2012, 2008R2, 2008, 2005, 2000
- SQL Server Express 2008 and 2005
- SQL Azure
What else can be compared?
- Snapshots of schemas (of all SQL Server versions listed above)
- SQL Server 2012, 2008R2, 2008, 2005 backup files
Supported schema objects
- Application Role
- Assembly
- Asymmetric Key
- Broker Priority
- Certificate
- Contract
- DDL Trigger
- Default
- Event Notification
- Full Text Catalog
- Full Text Stoplist
- Function
- Message Type
- Partition Function
- Partition Scheme
- Procedure
- Queue
- Remote Service Binding
- Role
- Route
- Rule
- Schema
- Search Property List
- Sequence
- Service
- Symmetric Key
- Synonym
- Table
- User
- User Defined Type
- View
- XML Schema Collection
What non-schema objects can be synchronized?
- Database properties
- Objects' extended properties
- Per-object security permissions
T-SQL code comparison features
- Ignore white spaces and comments in code
- Ignore differences in identifier and keyword case
- Decrypt and compare encrypted objects
How can I analyze comparison results?
- Filter, group, and sort objects in results
- View DDL differences for each pair of objects
- Preview schema update script for each object
- Generate schema comparison report in Excel and HTML formats
Synchronization features
- Create accurate synchronization scripts
- Migrate any schema differences (individual, selected, or all)
- Dependency check to script objects in the correct order for updates
- Automatic resolving of synchronization issues
- Warnings on controversial points prior to synchronization
How can I automate my routine tasks?
- Save comparison project settings for future use
- Use command line interface for automatic routine synchronizations
Schema snapshots and version control integration
- Create schema snapshots for audit and roll-back purposes
- Automatically commit snapshots to version control system
- Compare previous versions of schema with current one (integration with Team Foundation
Server and Subversion supported)
View the list of features regarding editions at the Editions
page.