How to force DACPAC to update only one scheme?

Question

I have a VS2013 solution with a * .sqlproj project that contains objects specific to this solution. The problem is that this is a common database for other projects.

My problem is to automatically deploy changes to my schema in the database without affecting other objects. By default, DACPAC updates the entire database, which in my case is undesirable.

I tried to write a deployment contributor http://msdn.microsoft.com/en-us/library/dn268597(v=vs.103).aspx, but it does not seem to be in the solution folder, since it is in the Program Files subfolder SQL Server

I use Bamboo to create deployment packages, and the application is hosted in Microsoft Azure with an Azure SQL database.

Is it possible to somehow deploy database changes only in my schema using DACPAC or other automatic means?

Answer 1

Your two options:

• SqlPackage.exe DLL- DAC , . DLL . , SqlPackage.exe . DLL , Microsoft.Data.Tools.Schema.Sql.dll, , , .

• , , dacpac, DropObjectsNotInSource = false. , , , , / .

, API. . , №1 ( , , /), . , API ( SqlPackage.exe) .

Answer 2

, DacpacMarge, DacPac. Dacpac , .