What is the difference between Windows with SQL Standard and Windows with SQL Web?

Hi there;

What is the difference between Windows with SQL Standard and Windows with SQL Web which amazon proposes? http://aws.amazon.com/windows/

I need to know how relevant they are for my installation of a program in which using H2 database. Any restrictions?

LVL 12
Who is Participating?
pcelbaConnect With a Mentor Commented:
I don't know H2 in details so I cannot tell what functionality could be missing on MS SQL Server.

You may download MS SQL Express + SQL Management Studio for a free to your local PC and look what is missing and how to replace it.

To compare MS SQL Server editions you may look here: https://www.microsoft.com/en-us/sqlserver/editions.aspx
and here: http://msdn.microsoft.com/en-us/library/cc645993.aspx
Older versions are compared here: http://www.microsoft.com/en-in/sqlserver/product-info/compare.aspx

A short comparison is here: http://www.save9.com/2012/09/sql-server-2012-editions-compared/
The difference is in licensing. SQL Server web edition requires monthly cost through Microsoft's Service Provider License Agreement (SPLA) whereas SQL Server Standard requires either CALs (depends on number of clients) or CPUs (depends on number of CPUs) licensing.

But you will pay to Amazon so the licensing model is not so relevant for you. More info: http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/web.aspx
jazzIIIloveAuthor Commented:
So, there is no actual difference? and my database is on h2. What would be the trade off for me?

You don't need SQL Server for H2 database, you don't even need Windows for H2 database. Some Linux cloud could be sufficient. But depends what everything you need...

MS SQL Server will be faster than H2 for sure but the client speed depends also on the internet speed which is the bottleneck obviously.
jazzIIIloveAuthor Commented:

My current need is to replace H2 with MSSQL as I am under W2008, but the version of MSSQL is a question in terms of missing functionality. So, what should I do?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.