Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

Toad for SQL Server 6.6

You are here: Compare Data > Data Types Affected by Comparison Options

Data Types Affected by Comparison Options

The following table displays the data types that are affected based on options you select in the Comparison Options page (Tools | Options | Data Compare | Comparison) or the Select Comparison Options page in the Data Compare wizard.

 

Ignore BLOB

Ignore Case

Ignore GUID

Ignore Auto-Increment

Ignore Timestamp

Ignore Whitespaces

SQL Server Data Types

Binary

Varbinary

Image

Sql_variant

Text

Ntext

Char

Varchar

Nchar

Nvarchar

Text

Ntext

Uniqueidentifier

UDDT CLR

XML

Uniqueidentifier

Ignores incrementing an identity column (Column usually has an Integer data type)

Timestamp

Char

Varchar

Nchar

Nvarchar

Text

Ntext

Uniqueidentifier

UDDT CLR

XML

  

Related Topics

of