Fine-Tune Data Comparison to Maximum Precision with Custom Queries

dbForge Data Compare for SQL Server adds an extra level of flexibility to your comparison operations. Now you can easily tailor the output to your most precise requirements with custom queries. The results of their execution can be compared selectively, as opposed to comparing the data of entire tables or views in your database.

  • Easy setup via Data Comparison Wizard
  • Custom query mapping
  • Comparison of queries against tables and views or vice versa
  • Fast delivery of results in .dcomp files
How to Compare the Results of Custom Queries

Selecting Source and Target objects

Use the Data Comparison Wizard to get started. First, define the Source and Target objects for comparison (database, backup, or scripts folder) and specify them along with the required connections.

Setting up a custom query

Now you can proceed to setting up your custom query. In the Custom Queries Mapping dialog box, you have the option to select Query both for the Source and the Target. Then simply enter your query in the SQL field, specify its name in the Name field, and move on to mapping.

Custom query mapping

Check the Source and Target objects and launch the mapping of your query for further comparison and synchronization.

The comparison process

Launch the comparison and wait a few moments until dbForge Data Compare gets the job done.

Viewing the results

After the comparison is completed, you can view the differences, conveniently presented in a .dcomp file.

Data Compare
is part of dbForge Compare Bundle

Find out more

Leading companies choose dbForge Data Compare

Kenworth
International Paper
Wells Fargo
Paccar
Nordstrom

What people say

Leave a testimonial
I compared your product against several competing products as part of a consulting project for a client and found your product to be highly functional and well designed and at a price point well below competing software at a similar level. It fits nearly all of their needs and was a clear choice to recommend above the others. Kudos on a quality piece of software.
Kevin Locke
Digital Engine Software
First of all thanks for providing such great products on SQL Server and making life easier. I am a freelance developer, having good experience in developing software products with optimal performance.
Santhosh
Freelance Developer

Get started with dbForge Data Compare at no cost

Download a FREE 30-day trial and start saving time spent on your data comparison tasks today.

Download for free

Buy multiple licenses with a substantial discount

We provide flexible purchase options, including bulk discounts, to meet the budget of each and every customer.

Purchase now

Try SQL Tools with Data Compare included

Sync schemas, deploy from version control, write SQL code, and achieve more with our mega pack of SQL Server tools.

Find out more

Data Compare as part of DevOps Automation

Use Data Compare along with dbForge DevOps Automation for SQL Server to extend DevOps practices to SQL Server databases. The solution helps optimize productivity, reduce database release costs, and make the overall workflow consistent and safe.

Explore
dbForge DevOps Automation for SQL Server

Devart Discount Programs

Choose your free license, volume discount, or special offer

Learn more

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.