Different Data Base Editions in SQL Azure



There are two Data Base Editions in SQL Azure.

DataSqlAzure1.gif

The Web Edition Relational Database includes:

  • Up to 5 GB of a T-SQL based relational database*
  • Self-managed DB, auto high availability and fault tolerance
  • Supported by existing tools like Visual Studio, SSMS, SSIS, BCP
  • Best suited for Web application, Departmental custom applications

Business Edition DB includes:
  • Up to 50 GB of T-SQL based relational database*
  • Self-managed DB, auto high availability and fault tolerance
  • Additional features in the future like auto-partition, CLR, fanouts etc
  • Supported by existing tools like Visual Studio, SSMS, SSIS, BCP
  • Best suited for Saas ISV applications, custom Web application, Departmental applications

While creating a database in SQL Azure, we can choose either of two options

DataSqlAzure2.gif

If we choose Web Edition then the maximum size we can choose is 5 GB.

DataSqlAzure3.gif

If we choose Business Edition then maximum size we can choose is 50 GB.

DataSqlAzure4.gif

The billing scheme for both editions is different.

Up Next
    Ebook Download
    View all
    Learn
    View all