3 ms·

Hi Felix, Azure SQL is very, very different from a regular MS SQL Server environment. It is a lot more restrictive and thus many tools (such as your own SQL Ma

Hi Felix, Azure SQL is very, very different from a regular MS SQL Server environment. It is a lot more restrictive and thus many tools (such as your own SQL Management Studio) do not work well with it. Is there any plan to make these two siblings more compatible with eachother? Furthermore, Azure SQL is very unclear about its performance guarantees. Your DTU's have no mapping to anything in the real world which we can compare. Are there any plans of addressing that?

Someone1234 12y ago
I couldn't agree more. I tried to get an Azure WebSites with an Azure SQL instance of Wordpress working. Getting PHP to run on Azure WebSites was easy/pleasant, getting Azure SQL to talk to PHP was an absolute nightmare and then even once that is done you have issues with instance naming and paths. To be honest I completely gave up. I spent three days on the above setup, and never did get Wordpress working. Then after I gave up I spent one afternoon setting up the same thing using an Azure VM. I like the concept of Azure Websites, but Azure SQL is just "meh." It isn't compatible with MS SQL which is a big problem frankly. A lot of stuff supports MS SQL out of the box, but it seems like Azure SQL is something else entirely. PS - Azure does have an MySQL compatible offering, but it is by a third party. Nothing by MS themselves. So the pricing model is awkward.