![]() |
Learn more about Toad for SQL Server Find solutions and downloads at the |
Toad for SQL Server 6.6 |
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 |