Error When Comparing with a View

scarlettiscarletti Posts: 3
edited November 23, 2015 6:20AM in SQL Data Compare 11
I'm currently evaluating SQL Data Compare 11.

I'm currently trying to compare 2 replicated tables that have a slightly different schema. The source has a column that is a timestamp, but the target is defined as varbinary(8).

(the columns are the same data types under the cover, so I would have expected the compare to be happy provided the timestamp column isn't the target!!)

Anyhow, to work around this, I've created a view at the source that casts the timestamp column as varbinary(8), which I'm mapping to the target table. This works as long as I don't select the "Use checksum comparison" operator. If I do select that option (which I want to do in order to speed up the comparison), I get a "Validation failure" error telling me that my view doesn't exist.

Running SQL profiler, I can see that it is trying to run sp_table_validation against the view in both the source and the TARGET databases, even though it only exists in the source database.

Comments

  • Hi,

    This looks like a bug with reference SDC-1874. You might be able to work around it by creating a view in the target, using the same name as the view in the source, that is basically just SELECT * FROM ... and then comparing the views.

    Apologies.
    Software Engineer
    Redgate Software
  • When is this bug likely to be fixed... or better still, why not allow comparison of a Timestamp with a varbinary(8) if the Timestamp is the source column?

    This bug is causing a lot of follow on problems. When I use a view, I lose the parent/child sequencing of the deployment script, i.e. where it would delete child rows before parents, and insert parent rows before child rows. I also have to specify the comparison columns manually with a view.
Sign In or Register to comment.