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 6 (of 6 total)

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

Site Owners SSC Guru Points: 80356 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: 247180 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.

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: 247180 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.

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.