Multiple dacpac's in the same database

Question

I am new to Sql Server Data Tools, and have a question.

At our company we house multiple applications, some share the same database. Doing some testing with publishing dacpac's, it seems like there can only be 1 dacpac tracked at a time.

So, if I publish a dacpac called "MyApp1" to a database named "MyData", executing the following:

select * msdb.dbo.sysdac_instances_internal

Will give me:

instance_name = MyData
type_name = MyApp1

Now, if I publish another dacpac, "MyApp2", to the same database, I lose the initial dacpac installation in the above query. Now I only get the latest one installed.

Answer 1

After looking at the sysdac_instances_internal, I saw a unique constraint on the instance_name. Is there not a way to manage multiple dacpac deployments on the same database?

Answer 2

Anyone?

Answer 3

The sysdac_instances_internal script only records the last successful dacpac install.  Dacpacs have been designed such that it represents one complete database.  If you try multi-dacpacs in one database you'll have to create your own versioning system.