Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

If I deploy DACPAC over existing database will it wipe it?

Tags:

sql-server

I gave a backup of my SQL-Server database to a vendor, they made changes and sent me back a DACPAC. If I use SQLPackage.exe to deploy that DACPAC to the original database will it wipe the data in my tables?

My understanding is that a DACPAC is just schema. I'm worried my tables will be empty afterwards.

Thanks

like image 349
Mist Avatar asked Sep 11 '25 02:09

Mist


2 Answers

By default, executing a .dacpac will never cause data loss.

like image 100
ErikEJ Avatar answered Sep 13 '25 17:09

ErikEJ


This just happened to me, the deployment from visual studio dropped the database and re-created. I had enabled "Always re-create database" option in SqlProject properties / Debug left tab. May be helpful for someone

like image 44
Rod Ramírez Avatar answered Sep 13 '25 16:09

Rod Ramírez