Red Gate forums :: View topic - SQLCI.exe and migration scripts
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Deployment Manager
Deployment Manager forum

SQLCI.exe and migration scripts

Search in Deployment Manager forum
Post new topic   Reply to topic
Jump to:  
Author Message
dbaumnnmdp



Joined: 15 Nov 2013
Posts: 2

PostPosted: Fri Nov 15, 2013 9:22 pm    Post subject: SQLCI.exe and migration scripts Reply with quote

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/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: /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
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1121
Location: My desk.

PostPosted: Tue Nov 19, 2013 1:59 pm    Post subject: Reply with quote

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)
Back to top
View user's profile Send private message
dbaumnnmdp



Joined: 15 Nov 2013
Posts: 2

PostPosted: Fri Nov 22, 2013 10:50 pm    Post subject: Reply with quote

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/content/Automation_with_Red_Gate_tools/help/1.0/Switches_used_in_sqlCI
Back to top
View user's profile Send private message
DavidSimner



Joined: 04 Feb 2010
Posts: 49

PostPosted: Mon Nov 25, 2013 10:41 am    Post subject: Reply with quote

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-development/sql-source-control/entrypage/sql-source-control-migrations-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.
Back to top
View user's profile Send private message
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