Solved

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

Posted on 2013-11-27
5
890 Views
Last Modified: 2013-12-12
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
Comment
Question by:jazzIIIlove
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 42

Expert Comment

by:pcelba
ID: 39680334
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
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 39680354
So, there is no actual difference? and my database is on h2. What would be the trade off for me?


regards.
0
 
LVL 42

Expert Comment

by:pcelba
ID: 39680369
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
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 39680525
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
 
LVL 42

Accepted Solution

by:
pcelba earned 500 total points
ID: 39680538
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question