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.
Increase your Sitefinity skills by signing up for our free trainings. Get Sitefinity-certified at Progress Education Community to boost your credentials.
This free lesson teaches administrators, marketers, and other business professionals how to use the Integration hub service to create automated workflows between Sitefinity and other business systems.
This free lesson teaches administrators the basics about protecting yor Sitefinity instance and its sites from external threats. Configure HTTPS, SSL, allow lists for trusted sites, and cookie security, among others.
The free on-demand video course teaches developers how to use Sitefinity .NET Core and leverage its decoupled architecture and new way of coding against the platform.
To submit feedback, please update your cookie settings and allow the usage of Functional cookies.
Your feedback about this content is important