Forum for users of SQL Compare schema synchronization utility
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.
- Posts: 12
- Joined: Fri Apr 20, 2012 11:34 pm
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.
Red Gate Software
- Posts: 209
- Joined: Mon Apr 23, 2012 2:49 pm
Another approach is to create a filter in SQL Compare and to reference it in the command line using /filter
- Posts: 1136
- Joined: Mon Dec 05, 2005 4:54 pm
- Location: Twitter: @dtabase
Return to SQL Compare Previous Versions
Who is online
Users browsing this forum: No registered users and 0 guests