How to provide vsdbcmd deploy command line target dbschema sql command variables?

Question

The Visual Studio (2010) gui provides options for specifying second command variable file for target. I however cant find this option for the command line implementation - vsdbcmd.exe.

Running vsdbcmd deploy for dbschema to dbschema with only source model command variables given results that objects that implement the variables are treated as having changes. Resulting in incorrect(improper) update script.

The command i use currently:

vsdbcmd.exe /a:deploy /dd:- /dsp:sql /model:Source.dbschema /targetmodelfile:Target.dbschema /p:SqlCommandVariablesFile=Database.sqlcmdvars /manifest:Database.deploymanifest /DeploymentScriptFile:UpdateScript.sql /p:TargetDatabase="DatabaseName"

What im looking for is the /p:TargetSqlCommandVariablesFile, if such thing exists ...

The result script is the same as running so GUI compare without specifying the sqlcmd vars for target

Ryan Gates · Accepted Answer · 2015-04-14 21:22:56Z

1

I found what looks like full documentation for VSDBCMD.EXE at this link.

I think you may be looking for something like:

/p:SqlCommandVariablesFile=Filepath

edited Apr 14, 2015 at 21:22

Ryan Gates

4,5797 gold badges53 silver badges93 bronze badges

answered Mar 27, 2013 at 22:17

Tom

3663 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

drk Over a year ago

As by my original question this parameter i already use, however it doesnt impact the target dbschema resulting in script that treats any item with variable as change.

drk · Accepted Answer · 2013-01-15 14:33:06Z

0

In the end i found no info on the possibility to do what I required - checked vsdbcmd libs with IL spy for hidden parameters - didn't find any.

Reached my goal by parsing the dbschema files for both target and current and parsing the cmd variable values directly into them - then doing the compare on modified dbschemas. This approach no longer allows to change sql cmd vars in resulting script (as the values are already baked into code), however this was deemed as acceptable loss.

Not the most beautiful solution but so far i have had no issues with it.

answered Jan 15, 2013 at 14:33

drk

8655 silver badges9 bronze badges

Collectives™ on Stack Overflow

How to provide vsdbcmd deploy command line target dbschema sql command variables?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related