Red Gate forums :: View topic - Comparing specific objects from multiple databases
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Comparing specific objects from multiple databases

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Xaphan



Joined: 20 Apr 2012
Posts: 12

PostPosted: Fri Apr 20, 2012 11:43 pm    Post subject: Comparing specific objects from multiple databases Reply with quote

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.
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Mon Apr 23, 2012 3:12 pm    Post subject: Reply with quote

Unfortunately there is currently no way of comparing multiple databases in a single call of sqlcompare.exe. You can however specify the object type using the "/include" option when calling sqlcompare.exe through command line. If you are unfamiliar with the include option you can familiarize yourself by calling "sqlcompare /?" from the command line.

More information available at this link.
http://www.red-gate.com/supportcenter/Content/SQL_Compare/help/10.0/SC_CL_Getting_Started
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Mon Apr 23, 2012 3:50 pm    Post subject: Reply with quote

Another approach is to create a filter in SQL Compare and to reference it in the command line using /filter
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group