Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 949
  • Last Modified:

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?

Regards.
0
jazzIIIlove
Asked:
jazzIIIlove
  • 3
  • 2
1 Solution
 
pcelbaCommented:
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
0
 
jazzIIIloveAuthor Commented:
So, there is no actual difference? and my database is on h2. What would be the trade off for me?


regards.
0
 
pcelbaCommented:
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.
0
 
jazzIIIloveAuthor Commented:
Hi;

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?

Regards.
0
 
pcelbaCommented:
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/
0

Featured Post

Put Machine Learning to Work--Protect Your Clients

Machine learning means Smarter Cybersecurity™ Solutions.
As technology continues to advance, managing and analyzing massive data sets just can’t be accomplished by humans alone. It requires huge amounts of memory and storage, as well as the high-speed power of the cloud.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now