What's included in dbForge Compare Bundle?

Schema Compare
dbForge Schema Compare is your great way of managing differences in database schemas. It works with live databases, snapshots, scripts folders, native backups, and source control revisions. With its help, you can fine-tune a variety of settings, run comparisons, analyze differences, and generate error-free SQL scripts to deploy schemas from the source to the target. You can use this tool in your database development workflow to validate schema changes in a development environment before syncing them with production. You can just as well use it to recover database structures or migrate them to new environments. Moreover, you can set up automated comparison and synchronization operations with command-line scripts.

Data Compare
dbForge Data Compare is used to compare actual table data. It works with live databases, scripts folders, and native backups. Similarly to Schema Compare, you can configure a slew of settings, run comparisons, and analyze data differences. You can also compare static data against version-controlled databases and synchronize changes with just a few clicks. The use cases are also similar to those of Schema Compare. You can continuously monitor changes in your data. You can recover missing or damaged data from a native backup. Finally, you can migrate data from a source to a target environment in the easiest possible way. And take note that command-line automation applies here just as well.

Why choose Compare Bundle?

• Quick comparison of database schemas and table data - Both tools boast a simple and intuitive user interface, so you won't have any trouble figuring out your next step. Once you open the comparison wizard, you'll need to select the databases to be compared alongside their respective connections.
• Support for multiple schema objects - Schema Compare will help you spot differences and synchronize the following types of schema objects:
  • Application Role
  • Assembly
  • Asymmetric Key
  • Broker Priority
  • Certificate
  • Contract
  • DDL Trigger
  • Default
  • Event Notification
  • Symmetric Key
  • Full Text Catalog
  • Full Text Stoplist
  • Function
  • Message Type
  • Partition Function
  • Partition Scheme
  • Procedure
  • Queue
  • Sequence
  • Role
  • Route
  • Rule
  • Schema
  • and more
• Flexible customization - Both Сompare tools include convenient comparison wizards with multiple ways to fine-tune data and schema comparison.
  • General comparison options that allow including/excluding specific object types, database properties, etc.
  • Customizable auto-mapping and smart custom mapping options
  • Flexible comparison behavior for tables, triggers, indexes, constraints, replication objects, and script objects
  • The Custom Query feature of Data Compare that allows performing a bilateral comparison of a table with a custom query output
• Easy management of comparison results - After the comparison, the results will be presented in a comparison document, with differences conveniently highlighted for easy inspection.
  • Filter, group, and sort comparison results
  • View DDL differences for each pair of objects
  • Preview update scripts for each object
  • Generate comparison reports in CSV, XLS, and HTML formats
• Smart synchronization - If you need to sync your source schemas or data to your target, a corresponding wizard will help you do it in a matter of seconds.
  • Create accurate synchronization scripts
  • Review and edit scripts in the internal editor, save them to files, or execute them directly against the target database
  • Deploy individual, selected, or all schema differences
  • Perform dependency checks to script objects in the correct order
  • Resolve sync issues automatically
  • View warnings about possible issues prior to synchronization
• Automation of recurring tasks - You can easily make Schema and Data Compare part of your DevOps cycle. Configure your settings once, generate a command-line script, and run it at any given moment.
  • Save comparison project settings for recurring use
  • Generate PowerShell automation scripts
  • Save these scripts to .bat files and schedule their execution via Windows Task Scheduler