CODEWITHSUNDEEP
sql-server-2012azure-sql-database
Maheswara
Maheswara

Reputation: 33

What is the difference between SQl Server and SQL Azure

What is the main difference between SQL SERVER and SQL AZURE, What is the advantage of SQL Azure

Upvotes: 2

Views: 753

Answers (1)

Alberto Morillo
Alberto Morillo

Reputation: 15658

On this article you will find how they compare on topics like features, upgrades, limitations, TCO, business continuity, licensing, performance, security, data transfer and costs. SQL Azure has now more security features than the article show like row-level security, dynamic data masking, auditing, encryption, threat detection, and SQL Vulnerability Assessment as you can read here.

About the Transact-SQL differences of Azure SQL Database compared with SQL Server you will find them here. Some of the most important differences are you cannot rely db_id(), you cannot use DBCC DROPCLEANBUFFERS, linked servers are not available, cross database queries are allowed via elastic queries, some system stored procedures not supported, USE is not supported, four-part names not supported.

Upvotes: 2

Related Questions