Compare and Sync
SQL Server Schemas
dbForge Schema Compare for SQL Server is a reliable tool that saves your time and effort when comparing and synchronizing databases on SQL Server. The tool allows working with live SQL Server databases, snapshots, and backups. You can quickly compare your SQL Server databases, analyze differences and perform error-free schema synchronization using generated SQL scripts.
What else can be compared?
- Snapshots of schemas
- SQL Server 2014, 2012, 2008R2, 2008, 2005 backup files
- Custom mapped tables
What schema objects are supported?
- 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
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)
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
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
Generate Script
- Schema Export (Generate Script Wizard)
- Schema only backups in addition to full backups
- Large database support
- Generate Script projects to save settings for future use
- Zip compression for export files
- Command line support for scheduling schema export tasks
- Error and status logging
How can I automate my routine tasks?
- Save comparison project settings for future use
- Use command line interface for automatic routine synchronizations
What’s New in dbForge Schema Compare for SQL Server, v4.1
SSMS Integration Support
- SQL Server Management Studio integration enables starting the schema comparison directly from SSMS
Database script folder
- Database script folder creation and comparison
- Comparison with database script folder in version control
Support for all popular version control systems:
- Subversion (SVN)
- Team Foundation Server (including TFS Cloud)
- Perforce (P4)
- Mercurial (Hg)
- SourceGear Vault
User Interface
- Redesigned Comparison Document UI
Installation/Activation Instruction is Included in the folder!
Torrent Contain:
Size: 42MB
