sql data compare does not allow views to be compared
pfister
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??
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??
This discussion has been closed.
Comments
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.