SQL Server 2017 and Azure SQL Database Questions

Soldato
Joined
1 Nov 2007
Posts
6,411
Location
England
I'm thinking of building a mobile app and I need a backend to run in the cloud. I was looking at Amazon Web Services to start with as I am already somewhat familiar with their products but then I looked at Microsoft Azure and that got me thinking.

The main question I have is what edition of SQL Server 2017 is Azure SQL Database compatible with? Does it include all of the features from the Enterprise edition or is it one of the lower editions?

I'm still trying to get my head around Azure as there is a lot to take in but it does look somewhat promising.
 
I like Azure a lot. But AWS is more widespread and easier to hire people with experience in. If it's just me then I would go Azure. If it's a business consideration it would depend on the in-house expertise.

As to compatible versions, the Azure version of SQL server has its own release versions which I think generally run a little ahead of the distributed versions. I don't know exactly how they match up but I found a feature list comparison here:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-features

Probably has the answer you're looking for assuming you know specifically what features you're wondering about.
 
Back
Top Bottom