PREREQUISITES: You must use Microsoft SQL Server Management Studio 18.0 (or later)
Before you publish your project to Azure App Service, you must first upload your project's database to Azure SQL Database. Azure SQL Database is a database as a service solution providing intelligent, scalable, cloud database service and a broadest SQL Server engine compatibility. To get your Sitefinity website database running in Azure SQL Database perform the following steps:
To have your Sitefinity website database deployed to the cloud, you must first have a SQL server that will host your database. If you already have a SQL server in your Azure account, you can skip this step. If you don’t have one or want to create a new SQL server, follow the steps below:
NOTE: Keep a record of these details as you will need it later in the process to connect to your server.
Once your SQL Server has been created, you can now proceed with deploying your website database to Azure SQL Database. The process is facilitated in your local installation of SQL Server Management Studio (SSMS). You must connect to your SQL server in Microsoft Azure and deploy your local database there. Follow these steps:
NOTE: The above settings are the officially recommended minimum for a Sitefinity database. For more information about configuring and pricing options see Azure SQL Database pricing.
RESULT: Your database has been successfully deployed to Azure SQL Database. You can verify this by going to the Azure portal and clicking on (or searching for) SQL Databases:
NOTE: The instructions provided above are based on using SQL Server Management Studio (SSMS) for deploying your database to Azure SQL. If you encounter any problems while deploying your database, you can try an alternative approach using the Microsoft SQL Data Migration Assistant.
Sign up for our free beginner training. Boost your credentials through advanced courses and certification. Register for Sitefinity training and certification.
To submit feedback, please update your cookie settings and allow the usage of Functional cookies.
Your feedback about this content is important