What data types can be compared with Data Compare?

Last modified: March 2, 2023

The table below demonstrates what data types can be compared using dbForge Data Compare for SQL Server.

Type compatibility table

Checkmark - can be compared

C - explicit conversion is performed when comparing. A synchronization script will contain already converted data. On the Different, Equal, and Only in Target tabs in the Data Comparison document, you will see data in Target data type, Only in Source will display data in the Source data type.

Exclamation mark - possible data loss

Empty cells mean that these type pairs cannot be compared.

To learn how to set up and compare databases in SSMS, refer to Compare data in SSMS.

Want to find out more?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by Data Compare for SQL Server.

All features

All features

Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.

Request a demo

Request a demo

If you consider employing this tool for your business, request a demo to see it in action.

Data Compare for SQL Server logo

Ready to start using  

Data Compare for SQL Server?

Download a FREE 30-day trial