IF (DB_ID(N'$(DatabaseName)') IS NOT NULL)BEGIN DECLARE @stampValue nvarchar(128), @stmt nvarchar(4000), @parm nvarchar(4000) SELECT @stmt = N'USE [$(DatabaseName)] SELECT @valueOUT = CAST(value as nvarchar(128)) FROM ::fn_listextendedproperty(''microsoft_database_tools_deploystamp'', null, null, null, null, null, null)', @parm = N'@valueOUT nvarchar(128) OUTPUT' EXEC sp_executesql @stmt, @parm, @valueOUT = @stampValue OUTPUT IF (@stampValue = CAST(N'c4b9a607-e198-4907-b0e0-edef35034203' AS nvarchar(128))) BEGIN RAISERROR(N'Deployment has been skipped because the script has already been deployed to the target server.', 16, 100) WITH NOWAIT RETURN ENDENDGO
tf properties project /version
msbuild my.dbproj /t:sqlbuild /p:Configuration="myconfig";TFSVersion=OutputVariablemsbuild my.dbproj /t:sqldeploy /p:Configuration="myconfig";TFSVersion=OutputVariable
exec sys.sp_addextendedproperty @name = N'TFSVersion', @value = $(TFSVersion)