How to Use dbForge Schema Compare for SQL Server to Streamline Database Deployments

Top Features of dbForge Schema Compare for SQL Server (and How to Use Them)

dbForge Schema Compare for SQL Server is a focused tool for comparing and synchronizing database schemas. Below are its top features and concise, actionable steps showing how to use each one.

1. Accurate Schema Comparison

• What it does: Compares objects (tables, views, stored procedures, functions, types, triggers, etc.) between two SQL Server databases, snapshots, or a database and a source control folder.
• How to use:
  1. Open Schema Compare and set the Source and Target (databases, snapshots, or scripts folder).
  2. Click Compare.
  3. Review the results grid showing added, changed, and deleted objects.
  4. Use filters to focus on object types or change types.

2. Visual Difference Viewer

• What it does: Shows side-by-side object definitions with color-coded differences for quick inspection.
• How to use:
  1. In the comparison results, select an object marked as different.
  2. The viewer displays Source and Target definitions side by side.
  3. Use navigation controls to jump between differences and copy fragments if needed.

3. SQL Synchronization Script Generation

• What it does: Generates a safe, editable synchronization script to apply schema changes from Source to Target.
• How to use:
  1. After comparing, select the objects to include in synchronization.
  2. Click Synchronize → choose Create script.
  3. Review and edit the generated script in the built-in SQL editor.
  4. Optionally, execute the script directly or save it for deployment.

4. Deployment Preview and Execution

• What it does: Lets you preview deployment actions and execute synchronization with transaction support and backup options.
• How to use:
  1. From the generated script, choose Synchronize → Deploy.
  2. Review the deployment summary and enable options (wrap in transaction, create backups).
  3. Execute and monitor progress; view detailed logs on completion.

5. Filtering and Rule-Based Comparison

• What it does: Apply filters and rules to include/exclude schema objects or ignore specific differences (e.g., whitespace, permissions).
• How to use:
  1. Open comparison options before running Compare or from results via Options.
  2. Set rules (ignore owner, ignore filegroup, ignore comments) and object filters (by name pattern or type).
  3. Re-run Compare or refresh results to apply filters.

6. Schema Snapshots and Baselines

• What it does: Create snapshots to capture schema state for audits, testing, or offline comparison.
• How to use:
  1. Choose Create snapshot from the database context menu.
  2. Save snapshot to disk.
  3. Use snapshot as Source/Target in comparisons to analyze historical changes.

7. Integration with Source Control

• What it does: Compare a live database with a source-controlled scripts folder to keep schema changes in version control.
• How to use:
  1. Point Source/Target to the database and the scripts folder (local VCS working copy).
  2. Compare and generate scripts to apply or commit changes to source control.

8. Command-Line and Automation Support

• What it does: Run comparisons and generate synchronization scripts from CLI for CI/CD pipelines.
• How to use:
  1. Use the command-line utility (check product docs for exact parameters).
  2. Script comparison and sync steps in build pipelines to automate schema deployments.

9. Detailed Reporting and Logs

• What it does: Produces reports and logs for audits and troubleshooting, including actions taken during synchronization.
• How to use:
  1. Enable logging in options or choose report generation after comparison.
  2. Save or export reports for compliance and review.

10. Safe Modification Handling (Dependencies & Order)

• What it does: Detects object dependencies and orders synchronization actions to avoid errors during deployment.
• How to use:
  1. Let the tool analyze dependencies during Compare.
  2. Review the planned action order in the generated script and adjust manually only if necessary.

Quick Workflow Example

1. Create a snapshot of the production database.
2. Compare snapshot (Source) with local development database (Target).
3. Review differences using the Visual Difference Viewer.
4. Select changes and generate synchronization script.
5. Review, enable transaction backup, and deploy in a staging environment.
6. Run final comparison to confirm synchronization.

Final Tip

Always create backups or snapshots before deploying schema changes and run synchronization first in a staging environment.