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
Post a Comment