Azure  

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.