What are the challenges you face when working across database platforms? Take the survey

Comparing specific objects from multiple databases

XaphanXaphan Posts: 18
edited April 23, 2012 10:50AM in SQL Compare Previous Versions
My company is setting up continuous integration (using Cruise Control .NET) to deploy SQL Reporting Services reports automatically on a test server. Some of our reporting projects use only certain stored procedures and some may be in different databases. For example a report may use stored procedure A and B in Database X and Stored procedure C in database Y.

In my continuous integration app I want to call SQLCompare.exe and tell it to only compare a list of object in each database. Is there a way of doing this? If so, please provide an example if possible.


Sign In or Register to comment.