How can we help you today? How can we help you today?

sql data compare does not allow views to be compared

I have some view for data compare which are select * from base table
but have a filter to limit the compare to 20,000 rows of a 25 million row table. I could get managment to buy another copy if view worked??
pfister
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hello Pfister,

    Yes Data Compare will allow you to compare views -- provided they have a unique index on them. If your version of SQL Server supports it, you can create a view with a unique/clustered index and provided there is a matching view in each database, SQL Data Compare will allow you to compare the views rather than the table they're based on.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.