sql data compare does not allow views to be compared

pfisterpfister Posts: 4
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??


  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
This discussion has been closed.