Azure SQL Limitations?

Erik Kozlowski asked on September 19, 2022 22:17

On the predeployemnt checklist here, the following is noted regarding db deployments.

Your database may contain custom database objects that are not supported on Azure SQL. Because of this limitation of the Azure platform, you might not be able to migrate your database to Azure SQL without modifications. You might encounter issues when deploying your database to Azure if you have somehow customized your database (stored procedures, indexes, access to tables) or if you have developed custom modules.

Is Azure effectively looking for a vanilla Kentico db setup then? Or are there very specific cases where it would cause an issue to have things like custom stored procedures etc.

Correct Answer

Brenden Kehren answered on September 20, 2022 16:12

Azure SQL doesn't care at all about Kentico or if the database contains a vanilla version of Kentico. What it cares about is the pieces that may have been created in a non-Azure SQL environment that is not supported in the Azure SQL environment. Check out this page for a comparison. Long story short, if you followed Kentico best practices, you should have no issues.

0 votesVote for this answer Unmark Correct answer

Recent Answers

Erik Kozlowski answered on September 20, 2022 16:18

Thank you Brenden, that attached link is exactly what I needed.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.