Updated: May 31, 2023 (December 17, 2022)

  Analyst Report

Licensing SQL Server for Development and Test

My Atlas / Analyst Reports

2,056 wordsTime to read: 11 min
Wes Miller by
Wes Miller

Wes Miller analyzes and writes about Microsoft’s security, identity management, and systems management technologies. Before joining Directions on Microsoft, Wes... more

  • Visual Studio and MSDN Platforms subscriptions entitle users to SQL Server for development and test purposes.
  • SQL Server production licenses can be used for development and test purposes but could be more costly.
  • Developer edition is freely downloadable for development and test purposes, but it should be used carefully.

Organizations build many solutions with SQL Server database, reporting, and business intelligence (BI) technologies. During development (dev) and testing (test) and prior to being moved into production, such technologies must be properly licensed. While customers can use production SQL Server licensing for dev/test, this approach is often expensive and carries additional administrative overhead. Alternatively, special licensing options are available for dev/test workloads that can help minimize overall licensing cost, compliance overhead, and audit risk, but with the trade-off of limited use rights or technical limitations. Organizations need to consider their existing production licenses and development workloads to determine the most cost-effective licensing option.

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now