I am using SQLPackage.exe with database publish profiles to deploy database changes to DEV and QC instances. I have databases in simple recovery mode. But when I deploy changes using SQLPackage, it reverts them to full recovery mode.
This is what I am using,
"C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\SqlPackage.exe" /Action:Publish /SourceFile:"FILE PATH TO .DACPAC" /Profile:"PUBLISH PROFILE.XML"
If I use Visual Studio to deploy project changes using same publish project, same happens.
What am I missing here? As far as I can tell, there is no such flag in Profile. Is this expected behavior of SQLPackage?