DIFFERENCES BETWEEN SQL AZURE AND SQL SERVER

Posted on : 30-06-2011 | By : Devi Prasad | In : SQL AZURE

Share:

0


SQL Azure is in very very similar to SQL Server in terms of TSQL and other common features in SQL Server. But there are few limitations of SQL Azure with respect to SQL Server.

SQL Azure does not support the following:

  • MASTER DATA SERVICES (Introduced in SQL Server 2008 r2)
  • SQL Server Utility
  • Common Language Runtime (CLR)
  • Service Broker
  • Database Mirroring
  • XML Indexing
  • Database Mirroring
  • Backup and Restore
  • Backup and Restore (SP’s from DLL’s)
  • SQL Server Agent
  • Replication
  • Table Partitioning
  • SQL Server Replication
  • Resource Governor
  • PolicyBased Management
  • Large User Defined Data Types
  • Full-Text Search
  • Data Compression
  • Extension methods USING CLR
  • Extension spatial types USING CLR
  • External Key Management
  • Sparse Columns
  • Transparent Data Encryption
  • Data Auditing
  • UDAs – User Defined Aggregates
  • Data Collector
  • FILESTREAM
  • Extended Events



References : Devi Prasad (sqlserverlearner.com)

Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.


Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.




Write a comment