Using Azure to host your development database
Published 31 July 2019
To configure your project with a development database hosted on Azure, you'll need to configure the following settings:
Your development database should be set to your Azure instance/database.
The shadow database can be located on Azure if using a project with custom scripts provisioning. If you do need to locate your shadow database on Azure, it will probably be necessary to tweak the
DropDatabase.sql scripts to improve the performance of these operations on Azure.
Database schema provider
The database schema provider should be set to either Microsoft Azure SQL Database or Microsoft Azure SQL Database v12. This ensures that the deployment package produced during the build process is compatible with Azure.
In Visual Studio, you can set this property by choosing a Target Platform of either Microsoft Azure SQL Database or Microsoft Azure SQL Database v12.