sql - Updating Data-Tier Application version via SqlPackage.exe -


i automating deployment of applications database via command line using sqlpackage.exe, unable find way update version of data-tier application

(development, of course...)

http://msdn.microsoft.com/en-us/library/hh550080%28v=vs.103%29.aspx

i using /action:publish push newly built *.dacpac, version remains @ v1.0.0.0, if not possible? how how change extendedproperty?

i want have reference version installed looking @ database.

any ideas?

on database project go project settings, there section output types, click on properties button below "data-tier application (.dacpac) file):

in dialog can set version number gets deployed, can query information from:

select top 1000 [instance_id]       ,[instance_name]       ,[type_name]       ,[type_version]       ,[description]       ,[type_stream]       ,[date_created]       ,[created_by]       ,[database_name]   [msdb].[dbo].[sysdac_instances] 

Comments

Popular posts from this blog

javascript - Count length of each class -

What design pattern is this code in Javascript? -

hadoop - Restrict secondarynamenode to be installed and run on any other node in the cluster -