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