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

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

2

Best Answer

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

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

Random Posts

What is difference between monolithic and micro kernel?How to list (and count) all the models in a DBT project?How to fix "The requested app is not available or doesn't exist." in TestflightDownload .vhd image from Azure to local machine, and upload to another Azure accountHow to build a simple RSS reader in Python 3.7?How can I make a modal like in the picture - discordTypeError: 'bool' object is not subscriptable Python 3How to wrap any content or element outside table tr tag with tr or td tags properly?Java NIO FileChannel versus FileOutputstream performance / usefulnessWarning: comparison with string literals results in unspecified behaviourHive's unix_timestamp and from_unixtime functionsConfirming Password is still displaying "Passwords do not match" even when passwords do matchHow to stop Python closing immediately when executed in Microsoft WindowsGood C string library [closed]how do I compare 2 functions in javascriptHow to solve "Missing Marketing Icon. iOS Apps must include a 1024x1024px"OR-ing bytes in C# gives int [duplicate]changing top padding in javascriptChrome give error **Failed to load resource: net::ERR_NAME_NOT_RESOLVED** while other browser load imagesSpring boot gradle build fails