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

gcuhipw9 于 2023-04-28 发布在其他

关注(0)|答案(2)|浏览(149)

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

sql-server

来源：https://stackoverflow.com/questions/60689468/if-i-deploy-dacpac-over-existing-database-will-it-wipe-it

2条答案

按热度按时间

qpgpyjmq1#

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

赞(0）回复(0）举报 2023-04-28

dba5bblo2#

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

赞(0）回复(0）举报 2023-04-28

我来回答

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

2条答案

相关问题

热门标签

最新问答