SQLCI.exe and migration scripts

dbaumnnmdp

We are running SQLCI.exe for automating our SQL Server schema and static data changes as part of a TFS 2010 build. We are following the documentation found in this link: http://documentation.red-gate.com/displ ... n+Service#. We are deploying from source control directly to a downstream database with these additionalCompareArgs: /options:Default,IgnoreUsers,IgnorePermissions.

Basic schema changes and static data added via SQL Source Control come over just fine. However, if we require a migration script that doesn't appear to be run by the sqlci.exe.

Migration scripts run fine using the SQLCompare UI.

Thanks,

Dave

James B

Hi,

The SQL Compare Command Line requires different options to use migration scripts.

You'd need to have created two XML files, one for each of the extended properties we add to the database (storing the scripts location and the migration scripts location), then reference these using the /scriptsfolderxml and /migrationsfolderxml switches. In addition, you'd then use the /sourcecontrol1 and /revision switches.

See the full list of switches here (and please ignore if it says that the migrationsfolderxml is deprecated, it's still needed I think)

dbaumnnmdp

Hi James,

Thanks for your reply. However, we are not using SQL Compare directly but rather interfacing through the SQLCI.exe as indicated in the link. We are using MSBuild projects to construct the command line used to in conjunction with SQLCI.exe.

More information can be found here: https://www.red-gate.com/supportcenter/ ... d_in_sqlCI

DavidRG

We're currently in the process of re-writing the migrations functionality and sqlCI.exe will be updated towards the end of this re-write: http://www.red-gate.com/products/sql-de ... tions-beta

Until then, you can work around this problem by calling the SQL Compare command line directly as James suggested -- sqlCI uses the SQL Compare command line under the hood, and if you look at the output of sqlCI it should tell you precisely how it is calling SQL Compare command line. You'll need to adjust those command line arguments along the lines James said.