sql server - Change logical and physical file name when deploying dacpac -


when deploying dacpac first time using sqlpackage.exe how control logical , physical file names new database.

the standard sql statement be:

create database bar on primary (name = 'foo', filename = '...\foo\foo.mdf') log on (name = 'foo_log', filename = '...\foo\foo.ldf') 

it seems not possible out of box current tools. variables $(defaultfilepath) , $(defaultlogpath) control location cannot changed command line.

these values can changed using custom deployment contributor, see overriding defaultdatapath , defaultlogpath variables when using sqlpackage publishing dacpac.


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -

jdbc - Not able to establish database connection in eclipse -