sql-server-2012-vs-sql-2014-comparison

What’s the Difference Between SQL Server 2012 and SQL Server 2014?

Microsoft’s SQL Server is providing its services as a Relational Database Management System (RDBMS) and now has become a compelling choice for the Enterprise RDBMS deployment. Several subsequent versions of SQL Servers have been released by Microsoft. Below is our guide to help you properly and safely license SQL Server.

SQL Server 2012 Licensing Models

There are two licensing models in SQL Server 2012:

  1. Core-Based Licensing
  2. Server and Client Access License (CAL) Licensing
  • For Enterprise Edition, you need Core-Based Licensing
  • For Business Intelligence Edition, you are required to have Server and CAL based Licensing.
  • For Standard Edition, you can choose between Core-Based Licensing and Server and CAL based licensing.

Core-Based Licensing:   

This mode of licensing is used when the number of users or clients are uncountable. The license is sold for two cores and a minimum of 4 cores licenses are sold for a server. Each process on each machine is required to have a minimum of 4 cores licensed otherwise it is not sold.

Server and Client Access License Licensing:

This mode of licensing is used when the number of users or the clients is pre-determined and when you know that the number is never going to grow. In this scheme, each machine that is a client needs a CAL and a server needs a separate license.

Pricing:

 

SQL Server 2014 Licensing Models

There are two licensing models in SQL Server 2014:

  1. Core-Based Licensing
  2. Server and Client Access License (CAL) Licensing
  • For Enterprise Edition, Core Licensing is a requirement.
  • For Business Intelligence Edition, you are required to have Server and CAL based Licensing.
  • For Standard Edition, you can choose between Core-Based Licensing and Server and CAL based licensing.

Core-Based Licensing:  

This mode of licensing is used when the number of users or clients are uncountable. The license is sold for a pack of two cores and a minimum of 4 cores licenses are sold for a server. Each process on each machine is required to have a minimum of 4 cores licensed otherwise it is not sold.

Server and Client Access License Licensing:

This mode of licensing is used when the number of users or the clients is pre-determined and when you know that the number is never going to grow. In this scheme, each machine that is a client needs a CAL and a server needs a separate license.

Pricing:

$875 per Server

$205 per CAL

$3399 For the 2-Core

Have questions about SQL Server 2012, 2014 or 2017 Licensing? Call our Microsoft Certified experts at Royal Discount. We’ve been helping businesses properly setup their SQL Server environments for over 15 years running. Get in Touch Here – 1-877-292-7712.