Multiple Database Deployment using DACPAC

Question

Post reply

Multiple Database Deployment using DACPAC

Alone

Right there with Babe

Points: 783
More actions
November 1, 2022 at 3:59 pm

#4107323

Dear All,
I am able to deploy single database using DACPAC and VS Solution ,Post deployment scripts .But now I have to deploy multiple databases to same instances .Can you please guide how to do that using DACPAC. Do need to create DACPAC and VS solutions for each database ?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80325 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Phil Parkin SSC Guru Points: 246977 More actions · Answer 2

One of the arguments for the SQLPackage command line (link) when Publishing a DB is TargetDatabaseName. Using this, it's quite straightforward to deploy the same DACPAC to multiple databases.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Alone Right there with Babe Points: 783 More actions · Answer 3

Thanks for this Response. I have come across this link but not clear how to deploy multiple DACPACs for multiple databases.

Phil Parkin SSC Guru Points: 246977 More actions · Answer 4

Alone wrote:

Thanks for this Response. I have come across this link but not clear how to deploy multiple DACPACs for multiple databases.

Multiple calls to sqlpackage.exe, with as many different source/target arguments as necessary, should do it.

If that is not the answer you are looking for, perhaps you would explain why.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

zaidmughal Newbie Points: 1 More actions · Answer 5

Target Database Name is one of the options for the SQL Package command line link when publishing a DB. It is quite simple to deploy the same DACPAC to several databases using this.