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 ?

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  November 2, 2022 at 4:10 pm

  #4107829

  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: 247158

  More actions

  November 2, 2022 at 9:20 pm

  #4107924

  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

  November 3, 2022 at 3:42 pm

  #4108299

  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: 247158

  More actions

  November 3, 2022 at 3:48 pm

  #4108301

  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

  November 4, 2022 at 9:43 am

  #4108601

  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.