Create a DACPAC to only update not replace a SQL Server Database

• Weegee71

  SSChasing Mays

  Points: 607

  More actions

  September 27, 2022 at 2:52 pm

  #4092506

  Hi there

  We have been creating a DACPAC from a SQL server database project withing .Net Rider using the

  SQL Package command.

  This has been removing and replacing the database on target machines.

  But is there a way to just update a database rather than replace it?

  Can this be done by creating a dacpac which just has updated objects...or to place a switch in the

  SQLPackage command to update the database only?

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  September 27, 2022 at 3:19 pm

  #4092513

  Yes there is.

  SQLPackage /Action:Publish, with appropriate parameters.

  Set the CreateNewDatabase flag to false.

  ---

• Weegee71

  SSChasing Mays

  Points: 607

  More actions

  September 27, 2022 at 3:58 pm

  #4092539

  thanks Phil

  I tried this in my arguments

  /p:CreateNewDatabase:False

   

  and i got the following error message:

  'CreateNewDatabase:False' is not a valid argument for the 'Publish' action.

• Weegee71

  SSChasing Mays

  Points: 607

  More actions

  September 27, 2022 at 4:00 pm

  #4092552

  sorry Phil.. I figured it out

  /p:CreateNewDatabase=False