DATA compare sqloptions

Rippo

Hi I need to be able to disable timestamp columns whilst performing a data compare. However I have found that I cannot achieve this.

After a some searching I found that the provide.options is set to default which has SqlOptions.IncludeTimestamps turned on. How do I turn of include timestampes. I have tried the following code but timestamps are still being compared


Dim provider As New SqlProvider
provider.Options = SqlOptions.None

NOTE:- I have found that the difference.DifferentRecords includes the timestamp column being different but the GetMigrationSQL does not. I am slightly confused by this

Thanks

Brian Donahue

Hello Rippo,

I would imagine that the timestamps doe not appear in the migration SQL because timestamps cannot be synchronized. Data Compare allows you to visually compare the timestamps, but since they cannot be synchronized they are probably left out of the synchronization automatically.

Timestamps may appear in the result store unless you specifically do not include the column for comparison, but if they are different this will not be used as a basis for telling you that the row is different. In other words, if the only difference is the timestamp column, the row should appear in the identical records result set.

If you find this isn't the case, please let me know about it.