We are running SQLCI.exe for automating our SQL Server schema as part of a TFS 2012 Team build. We are following the documentation found in this link: http://documentation.red-gate.com/display/SOC3/Using+Team+Foundation+Server+2012+or+Team+Foundation+Service#. We are deploying from source control directly to a downstream database with these additionalCompareArgs: /Filter:filter.scpf /LogLevel:Verbose.
I created the filter via the gui in the .scpf file, but it seems as if it isnâ€™t picked up. (Extract from the scpf file)
<Expression>(@NAME LIKE '%')</Expression> />
Extract of MSBuild log file:
C:\\Builds2\\>sqlCI.exe "/scriptsFolder:Database\\ScriptsFolder\\RegGateCI" "/databaseServer:MYSERVER" "/databaseName:WidgetShop" "/databaseIntegratedAuthentication" "/additionalCompareArgs:/Filter:filter.scpf /LogLevel:Verbose" "/licenseSerialKey:XXX-XXX-XXXX-XXXX"
sqlCI.exe -- Red Gate's SQL Continuous Integration v18.104.22.1684
STARTING: Verifying license
Exiting since no other command line options were passed.
Terminating application with exit code 0 to indicate success
COMPLETED SUCCESSFULLY: Verifying license
STARTING: Updating database
Starting: C:\\Builds2\\SC\\SQLCompare.exe /include="Identical" /include="StaticData" /scripts1="Database\\ScriptsFolder\\RegGateCI" /server2="MYSERVER" /database2="WidgetShop" /synchronize /Filter="filter.scpf" /LogLevel="Verbose"
SQL Compare Command Line V10.5.0.378
Retrieving migration scripts
Checking for identical databases
Inserting static data SQL into deployment script
Deploying changes (from DB1 to DB2)
DB1 = RegGateCI
DB2 = MYSERVER.WidgetShop
Role db_denydatareader == ==
Role db_backupoperator == ==
Role db_datareader == ==
Role db_accessadmin == ==
You can see that the filter to exclude roles were not picked up even the /filter switch was passed from SqlCI.exe to SqlCompare.exe.
I am new to this forum. Please feel free to point me to any existing solution which i was unable to find.