locked
what is the difference between azure sql and simple sql express database RRS feed

  • Question

  • what is the difference between azure sql and simple sql express database...???

    please give me the detail description


    Ashish Fugat (9960978134) Software Engineer
    Thursday, December 9, 2010 4:52 AM

Answers

  • Hello Ashish,

    While you can read about guidelines and limitation on SQL Azure, there is one essential difference, and that is: SQL Azure is Cloud Service (Software-as-a-Service) designed for high scalability, high availabilty, self healing and so on. While SQL Express can be installed and run on a single machine, it is not calable, it is not highly availaible and you can't plan disaster recovery with SQL Express. SQL Express is free, SQL Azure is paid, and is great value for money!

    If you design a Cloud Application, a Software as a Service, or just an application that requires High Availability, Scalability and durability for its data - you might consider using SQL Azure as your RDBMS.

    Thursday, December 9, 2010 9:46 AM
  • SQL Azure is a Cloud based solution hosted by Microsoft. There is a charge for this. SQL Express is the free version of SQL Server which you can download and install on your own hardware. There are limitations of SQL Express around database size, memory it can consume etc. When you compare both products you will see they are very different products
    Gethyn Ellis blog: http://www.gethynellis.com/
    • Marked as answer by Raymond-Lee Monday, December 20, 2010 3:25 AM
    Friday, December 10, 2010 8:27 AM

All replies

  • Hi Ashish,

    This article explains the limitations on SQL Azure.

     


    With regards,

    Patriek
    If this reply is of help to you, please don't forget to mark it as an answer.
    Thursday, December 9, 2010 9:02 AM
  • Hello Ashish,

    While you can read about guidelines and limitation on SQL Azure, there is one essential difference, and that is: SQL Azure is Cloud Service (Software-as-a-Service) designed for high scalability, high availabilty, self healing and so on. While SQL Express can be installed and run on a single machine, it is not calable, it is not highly availaible and you can't plan disaster recovery with SQL Express. SQL Express is free, SQL Azure is paid, and is great value for money!

    If you design a Cloud Application, a Software as a Service, or just an application that requires High Availability, Scalability and durability for its data - you might consider using SQL Azure as your RDBMS.

    Thursday, December 9, 2010 9:46 AM
  • SQL Azure is a Cloud based solution hosted by Microsoft. There is a charge for this. SQL Express is the free version of SQL Server which you can download and install on your own hardware. There are limitations of SQL Express around database size, memory it can consume etc. When you compare both products you will see they are very different products
    Gethyn Ellis blog: http://www.gethynellis.com/
    • Marked as answer by Raymond-Lee Monday, December 20, 2010 3:25 AM
    Friday, December 10, 2010 8:27 AM