What are the challenges you face when working across database platforms? Take the survey

Why SCA is creating a shadow db on Azure when clicked on refresh button


When I click on refresh button, SCA is creating a new db in the Azure sql. This is a big concern for me because this is additional cost incurring and forgetting to cleanup this after importing migration scripts will bill additional costs which is not acceptable by the client.

I am unable to understand why SCA is creating shadow database despite of setting "skip creating shadow datbase.." option in the VS project settings. Is it mandatory for SCA to create shadow db on the devopment db? can't it use localdb? How to avoid this unwanted azure billing

Best Answer

Sign In or Register to comment.