What's included in dbForge Compare Bundle?

Schema Compare
dbForge Schema Compare offers the simplest way of comparing and syncing differences in database schemas. With its help, you can configure comparison settings, save them to templates, launch quick comparisons, inspect differences, and generate SQL scripts to sync your schemas. This functionality can prove useful in a number of cases. For instance, you might need to double-check changes in your schema objects before deploying them to production. You might need to migrate schemas to new instances. Or maybe you need to run regular comparisons, and you'd rather do it using command-line scripts saved to batch files and scheduled for execution.

Data Compare
dbForge Data Compare will guide you in a similar way to dbForge Schema Compare, allowing you to fine-tune comparison settings to your preferences, run quick comparisons, present conveniently highlighted data diffs in easily readable documents, and generate sync scripts in no time. This tool works with live databases and scripts folders, and it's just as useful as its counterpart. You can keep an eye on changes in your data and present them in compelling comparison reports. You can easily migrate your data to new environments. And, just like in Schema Compare, you can set up regular comparison and synchronization operations from the command line.

Why choose Compare Bundle?

• Quick comparison of database schemas and table data - Schema Compare and Data Compare are twin applications with consistently designed interfaces and smart wizards that will make your management of diffs most intuitive and effortless. Whichever tool you are using, your first step is to get connected to your databases. Next, open the comparison wizard. Once you do it, you will be able to select a source and a target database for comparison.
• Support for multiple schema objects - Schema Compare will help you locate differences and synchronize the following types of schema objects:
  • Table
  • View
  • Procedure
  • Function
  • Trigger
  • Event
  • Package (MariaDB)
  • Sequence (MariaDB)
• Flexible customization - You can tailor the schema and data comparison processes to your requirements with a number of options available on the corresponding pages of the wizards.
• Easy management of comparison results - Once the tool completes your comparison, the results will be displayed in a comparison document, with differences conveniently highlighted for easy inspection.
  • Filter, group, and sort comparison results
  • Scrutinize DDL differences for each pair of objects
  • Generate comparison reports in CSV, XLS, and HTML formats
• Smart synchronization - If you need to sync your source database to your target one, simply hit the synchronization button to open the wizard and run the entire operation in several clicks.
  • Generate 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 differences
  • Perform dependency checks to script objects in the correct order
  • Resolve synchronization 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