
How to Upgrade SQL Server 2022 to SQL Server 2025: Step-by-Step Guide
Upgrade SQL Server 2022 to 2025 safely with a DBA-focused plan covering compatibility, backups, testing, rollback and post-upgrade checks.
SQL Server / SQL Server 2025 Licensing Explained: Core Licensing, CALs and Editions
SQL Server 2025 licensing becomes much easier to understand once you separate three decisions that are often mixed together:
edition -> licensing model -> required quantity
First decide whether the workload belongs on SQL Server 2025 Standard or Enterprise. Then determine which licensing model is available and appropriate. Only after that should you calculate how many licenses or core packs the deployment requires.
At a high level, SQL Server 2025 uses two important commercial licensing approaches:
Enterprise should not be treated as a Server + CAL option for a new SQL Server 2025 deployment.
Virtual machines add another layer because licensing a VM and licensing the underlying physical server are different approaches, and some virtualization, mobility and failover rights depend on Software Assurance, subscription status or other licensing conditions.
That makes one principle especially important:
Do not choose a Wholsalekeys product simply because its page says 2 Core, 16 Core, Standard or Enterprise. First establish what your architecture actually requires.
The differences that matter most are not every item in the feature matrix. They are the changes that affect capacity, development, workload management and upgrade planning.
| Decision | SQL Server 2025 Standard | SQL Server 2025 Enterprise |
|---|---|---|
| Per Core licensing | Yes | Yes |
| Server + CAL licensing | Yes | No for current new licensing scenarios |
| User/device counting required under Per Core | No | No |
| CALs required under Server + CAL | Yes | Not applicable as a current new Enterprise model |
| Core packs relevant | Yes when using Per Core | Yes |
| Physical server licensing | Possible | Possible |
| VM licensing | Possible, subject to applicable rules | Possible, subject to applicable rules |
| Virtualization benefits | Depend on licensing conditions and entitlements | New capability does not remove migration risk |
| Best first question | Core or Server + CAL? | How will the required cores/virtualization be licensed? |
This is why licensing begins with architecture rather than shopping cart quantity.
Licensing cannot be separated completely from edition selection.
SQL Server 2025 Standard and Enterprise are designed for different workload requirements, and the licensing options available to each edition are not identical.
Standard is the more flexible edition from a licensing-model perspective because it can be licensed using either:
Per Core
or
Server + CAL
That choice can matter substantially.
A server used by a controlled number of known employees may create a very different licensing question from a public-facing application accessed by thousands of unpredictable users.
For current new SQL Server 2025 Enterprise deployments, the relevant licensing model is Per Core.
That means the licensing calculation centers on the compute architecture rather than counting individual users or devices accessing SQL Server.
Enterprise should therefore be chosen because the architecture requires its capabilities, scale or relevant deployment rights, not simply because an organization would prefer to avoid CAL counting.
If edition selection is still unresolved, read our SQL Server 2025 Standard vs Enterprise guide first. Licensing becomes much easier once that decision has been narrowed down.
Per Core licensing licenses the compute resources running SQL Server rather than licensing each individual person or device that accesses it.
This can be attractive when access is:
The central advantage is that you do not need a SQL Server CAL for every accessing user or device under the Per Core model.
SQL Server core licenses are commonly packaged in multi-core units, including 2-core packs.
That distinction is important.
A product labeled “2 Core” should not be interpreted as:
“Buy one package and every SQL Server installation is licensed.”
It means the product represents a quantity of core licensing that contributes toward the deployment’s calculated requirement.
The infrastructure determines how many cores must be licensed. The product pack is then used to satisfy that requirement.
Core licensing is not always as simple as counting whatever number appears in a virtual-machine settings screen or server specification.
Minimum licensing requirements can apply depending on whether you are licensing physical infrastructure or individual virtual machines.
That means a very small VM should not automatically be assumed to require only one core license simply because it has one virtual processor configured.
Before purchasing, verify:
This is why the safest sequence is calculate first, purchase second.
Server + CAL approaches the problem differently.
Instead of primarily licensing the processor cores, the organization licenses the SQL Server and then licenses the users or devices that access it according to the applicable rules.
For SQL Server 2025, this option applies to Standard Edition.
CAL stands for Client Access License.
Conceptually, there are two access patterns to understand:
User CAL: associated with a user who accesses SQL Server.
Device CAL: associated with a device used to access SQL Server.
The appropriate choice depends on how people actually work.
Imagine an employee who uses:
If the licensing analysis is based on named users, counting that person may be more logical than independently counting every device the employee uses.
Now imagine a warehouse with a smaller number of shared terminals used by many employees across several shifts.
The access pattern is completely different.
A device-oriented model may deserve investigation because many workers are accessing SQL Server through a smaller set of shared machines.
The correct choice should be based on the real access pattern and the applicable license terms rather than a blanket statement that User CALs or Device CALs are always cheaper.
The simplest distinction is this:
Per Core: license the relevant compute resources.
Server + CAL: license SQL Server Standard plus the users or devices that need access.
Consider the business implications.
| Environment | Model worth investigating first | Reason |
|---|---|---|
| 25 known employees accessing one internal SQL application | Server + CAL or Per Core | Access is countable, so both deserve comparison |
| Public website backed by SQL Server | Per Core | External users may be numerous or unpredictable |
| Business application accessed by thousands of employees | Per Core deserves strong consideration | CAL counting can become operationally complex |
| Small office with known users | Server + CAL may be practical | User population can be clearly defined |
| Shared-device warehouse | Server + CAL with Device CAL analysis | Devices may be more predictable than individual users |
| Enterprise Edition deployment | Per Core | Server + CAL is not the current new Enterprise licensing model |
| Highly virtualized SQL estate | Detailed Per Core analysis | VM and physical-host licensing architecture becomes important |
This table identifies what to investigate. It does not substitute for a final licensing calculation
Choosing between User and Device CAL concepts should not be based only on employee headcount.
Ask who accesses SQL Server and how they access it.
Suppose 30 employees each have:
The number of devices could exceed the number of people considerably.
A user-oriented access model may therefore deserve investigation.
Suppose 90 employees rotate through 15 fixed workstations across several shifts.
The number of people is much larger than the number of access devices.
A device-oriented licensing analysis may make more sense.
Now consider:
This is no longer a simple headcount exercise.
Map the actual access paths before deciding which licensing approach fits.
One of the most dangerous assumptions in Server + CAL planning is:
“The user never connects directly to SQL Server, so the user does not count.”
Modern applications often place other software between users and the database.
For example:
User -> web application -> application server -> SQL Server
or:
Employee -> ERP system -> middleware -> SQL Server
A middle application does not automatically make underlying SQL Server access disappear from the licensing analysis.
This area is often described as indirect access or multiplexing and should be checked carefully against the applicable licensing terms.
Do not design a CAL strategy around the assumption that pooling connections through one service account converts many users into one SQL Server user.
Virtualization is where SQL Server licensing can become considerably more architectural.
There are two very different questions:
Those approaches should not be mixed casually.
Imagine a virtualization host running several VMs, but only one VM contains SQL Server.
Licensing the SQL workload at VM level may be an approach to investigate.
The calculation depends on the virtual cores assigned and the applicable minimum licensing rules.
Adding more virtual CPU to the SQL VM can therefore affect licensing requirements.
That is an architectural consideration, not merely a performance setting.
In more heavily consolidated environments, organizations may evaluate licensing SQL Server at the physical-host level instead.
This becomes particularly important when SQL Server Enterprise, virtualization density and rights associated with certain licensing programs are involved.
However, phrases such as “unlimited virtualization” should never be assumed merely because the product is Enterprise Edition.
Those benefits can depend on additional licensing conditions.
A SQL Server product license and additional licensing-program benefits are not necessarily the same thing.
Some Microsoft licensing rights associated with areas such as:
may depend on Software Assurance, subscription licensing or other specific conditions.
Consider a fictional company with:
The organization has two licensing approaches worth evaluating.
Because Standard supports Server + CAL licensing and the user population is known, Server + CAL deserves consideration.
The company would need to determine which users or devices require access and choose the appropriate CAL structure.
The same Standard deployment could instead use Per Core licensing.
In that case the analysis moves away from employee counting and toward the compute resources running SQL Server
Before choosing, confirm:
The important lesson is that Standard does not force this company into one licensing model.
The access pattern should drive the comparison.
Consider a fictional online platform with:
Trying to build the licensing model around counting individual customers or devices would create a very different operational problem from the previous scenario.
Per Core licensing removes the need to license every individual accessing user or device under that model.
The organization instead determines the core licensing requirement of its SQL Server deployment.
For an internet-facing application, that can make the licensing architecture easier to manage.
Confirm:
Do not purchase a 2-core or 16-core pack until the actual core requirement has been calculated.
Consider a fictional infrastructure team running SQL Server 2025 Standard in a VM.
The VM is hosted on a larger virtualization server alongside many unrelated workloads.
The SQL administrator wants to increase the VM’s CPU allocation because application demand is growing.
That sounds like a routine infrastructure change.
From a licensing perspective, it deserves another look.
When SQL Server is licensed at the individual VM level under Per Core licensing, the virtual compute assigned to the SQL workload is part of the licensing calculation, subject to applicable minimums and conditions.
Increasing VM compute should therefore trigger both:
Before changing the environment, confirm:
This prevents an infrastructure team from treating licensing as something that only matters during the original installation.
Now consider a fictional organization running:
This is not simply:
number of SQL VMs x product price
The organization needs an architecture-level licensing review.
The team should determine whether its strategy involves:
Only after those questions are answered should it calculate the required Enterprise core licensing.
Confirm:
For this type of environment, Enterprise may make technical sense, but purchasing the correct number of core packs still requires an infrastructure-level licensing calculation.
Wholsalekeys provides SQL Server 2025 products in different core quantities.
For Standard Per Core deployments, current product options include:
SQL Server 2025 Standard 2-Core License
and
SQL Server 2025 Standard 16-Core License
For Enterprise deployments:
SQL Server 2025 Enterprise 2-Core License
and
SQL Server 2025 Enterprise 16-Core License
The difference is licensing quantity, not a different SQL Server feature edition.
Suppose your completed licensing analysis determines that you need a particular number of licensed cores.
You can then use available core-pack sizes to fulfill that calculated quantity.
The wrong sequence is:
“A 16-core product looks convenient, so I’ll buy that and design the server around it.”
The correct sequence is:
“This architecture requires a validated amount of core licensing, so which available product quantities fulfill that requirement?”
That subtle distinction prevents both under-licensing and unnecessary purchasing.
The answer depends on how the SQL Server environment is being licensed.
If the strategy is physical-server Per Core licensing, physical processor/core rules become central.
If the strategy is licensing an individual VM, the calculation follows the applicable virtualized deployment rules instead.
This is why hardware specifications alone cannot answer a SQL Server licensing question.
Two organizations can own identical servers but require different licensing analyses because one runs SQL Server directly on the physical operating system while the other runs a small SQL VM on a large virtualization host.
Only when the chosen licensing model requires CALs.
Under Per Core licensing, individual SQL Server CALs are not required for every accessing user or device.
Under Standard Server + CAL licensing, the user/device access population becomes part of the licensing calculation.
If your organization is trying to decide between these models, count actual access patterns before comparing costs.
Do not base the calculation only on employee headcount.
External access is one reason Per Core licensing often deserves attention.
Imagine an SQL-backed application used by:
The number of users and devices may be difficult to predict and maintain accurately.
Per Core licensing avoids making every individual user/device the center of the licensing model.
That does not mean Per Core is automatically cheaper.
It means the licensing structure may better match the architecture.
Another common mistake is to calculate licensing for one SQL Server and assume the result applies to the whole environment.
Consider an architecture with:
Production SQL Server + reporting SQL Server + disaster-recovery server + test server
Those systems may not all have identical licensing treatment.
Edition, production use, passive/active behavior, development/test rights and Software Assurance or subscription entitlements can affect the analysis.
Do not assume the secondary server is “free” simply because it exists for recovery purposes.
Similarly, do not assume every server necessarily requires identical licensing without first checking its role and the applicable rights.
Production licensing and non-production SQL Server usage should not be casually mixed.
SQL Server provides development-focused edition options intended for development and testing scenarios, while production workloads require appropriately licensed production editions.
A database containing test data does not automatically make an environment non-production.
Ask what the environment actually does.
If business users depend on it operationally, treat that distinction carefully.
Use this sequence before buying:
If Standard satisfies the technical requirement, continue to Question 2.
If Enterprise functionality or scale is necessary, the licensing analysis moves to Per Core.
If the environment has a controlled number of known users or devices, evaluate Server + CAL alongside Per Core.
If access is broad or unpredictable, Per Core may be easier to manage.
Document exactly where SQL Server executes.
Do not calculate core licensing until this is clear.
This becomes particularly important in consolidated and Enterprise environments.
If yes, verify whether those rights require Software Assurance, subscription licensing or another qualifying condition.
Only now should you convert the calculation into 2-core, 16-core or other appropriate product quantities.
A 2-core or 16-core product is a purchasing unit.
It is not the licensing calculation itself.
Enterprise Edition and qualifying virtualization rights are related but separate questions.
Check the actual licensing conditions.
Middleware does not automatically turn many underlying users into a single licensed user.
Review indirect access carefully.
Not every licensing environment maps neatly to payroll headcount.
Understand who and what actually accesses SQL Server.
Standard gives you a choice.
Per Core can make more sense when access is difficult to count.
Company size alone does not determine the model.
Architecture and access patterns do.
Increasing virtual compute can have licensing consequences.
Include licensing review in infrastructure change management.
Never infer Software Assurance, subscription benefits, mobility rights, hybrid benefits or special failover rights unless the exact product includes them.
Before selecting a Wholsalekeys product, document:
If several of those fields are still marked “unknown,” you are not yet at the product-selection stage.
SQL Server 2025 Standard can be licensed using Per Core or Server + CAL models. SQL Server 2025 Enterprise uses Per Core licensing for current new licensing scenarios.
A 2-core product represents two cores of licensing quantity. It contributes toward the total licensing requirement calculated for the environment. It should not be treated as sufficient for every SQL Server installation simply because it is sold as one product.
Only when Standard is licensed under the Server + CAL model. Standard can also be licensed Per Core, in which case individual CALs are not required for each accessing user or device under that model.
Enterprise is licensed Per Core for current new licensing scenarios, so it is not purchased using the current Standard-style Server + CAL model.
Choose based on access patterns. A user-oriented model may suit employees using multiple devices, while a device-oriented model may deserve consideration when many people share a smaller number of devices.
Neither is universally better. Per Core can be practical for broad or unpredictable access, while Server + CAL can make sense for some Standard environments with controlled and countable users or devices.
Yes, but virtualized environments have specific licensing considerations. Confirm virtual core requirements, applicable minimums and any rights tied to Software Assurance or subscription licensing before calculating quantity.
Do not assume that simply from the Enterprise edition name. Virtualization rights can depend on how the physical server is licensed and on additional licensing conditions such as Software Assurance or qualifying subscriptions.
There is no single answer without knowing the edition, licensing model and deployment architecture. For Per Core licensing, determine the relevant core requirement. For Standard Server + CAL, determine the server licensing and applicable user/device access requirement.
The safest way to purchase SQL Server 2025 is to make three decisions in order:
1. Choose the edition.
Determine whether the workload belongs on Standard or Enterprise.
2. Choose the licensing model.
For Standard, compare Per Core with Server + CAL where appropriate.
For Enterprise, plan around Per Core licensing.
3. Calculate the quantity.
Determine physical or virtual licensing requirements, minimum core rules and any other conditions that affect your architecture.
Only then should you select the corresponding Wholsalekeys product.
For a Standard Per Core deployment, you can compare the SQL Server 2025 Standard 2-Core License and SQL Server 2025 Standard 16-Core License after calculating the required quantity.
If your workload needs Enterprise, calculate the architecture first and then compare the SQL Server 2025 Enterprise 2-Core License and SQL Server 2025 Enterprise 16-Core License.
For buyers still evaluating Standard more broadly, the SQL Server 2025 Standard product provides another relevant starting point.
The key rule is simple:
Do not buy a SQL Server license quantity and then try to make the infrastructure fit it. Design the environment, establish the licensing requirement, and then buy the quantity that matches.

Upgrade SQL Server 2022 to 2025 safely with a DBA-focused plan covering compatibility, backups, testing, rollback and post-upgrade checks.

Compare SQL Server 2025 vs 2022 across Standard limits, AI, JSON, Resource Governor and upgrade planning to decide when migration makes sense.

Compare SQL Server 2025 Standard vs Enterprise by cores, memory, HA, performance, AI features and licensing to choose the right edition.