How to upgrade SQL Server 2012 to SQL Server 2017, shall I need to purchase 2017 License.
How to upgrade SQL Server 2012 to SQL Server 2017, shall I need to purchase 2017 License.
Yes, you need to buy a new license. For exact pricing etc, contact your local representative. This is a technical forum, and licensing questions are not really in scope. You can only expect go get rudimental answers from techies about licensing.
A1:
Before upgrade you need to know this : https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2017?view=sql-server-ver15
Use code : select @@version
to verify your current version whether it is the supported version,
If not you can upgrade it to 2012 SP2 and then upgrade it to sql 2017.
And then upgrade as this : https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-ver15
A2:
Do you use one enterprise or standard? If yes, you need to purchase the product key.
About how to purchase the license,you can consult the license team:
For detailed information about the license issue, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. For international customers, please use the https://www.microsoft.com/en-us/licensing/worldwide to find contact information in your locations. Or you can go to https://www.microsoft.com/Licensing/servicecenter/default.aspx Please choose region/language and choose to call or have web. People there will help you more effectively.
If the reply is helped, please do "Accept Answer".
BR,
Mia
How to upgrade SQL Server 2012 to SQL Server 2017,
Firstly, please reference this before you doing upgrade: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2017?view=sql-server-ver15
Verify your version with next code: select @@version
If your version is not in the supported upgrading list, you need upgrade it to SQL2012SP2 or later, and then upgrade it to SQL2017
Steps for upgrading it to SQL 2017: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-ver15
shall I need to purchase 2017 License.
What is your version? Is it one enterprise or standard version?
If yes, you need one product key, a product key actually is one license key. More details about license purchasing, you can consult our license team.
For detailed information about the license issue, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. For international customers, please use the https://www.microsoft.com/en-us/licensing/worldwide to find contact information in your locations. Or you can go to https://www.microsoft.com/Licensing/servicecenter/default.aspx Please choose region/language and choose to call or have web. People there will help you more effectively.
If the reply is helped, please do “Accept Answer”.
BR,
Mia
1 Person is following this question.
Year and Month aggregation in same Pivot table in SQL Server
SQL Server Query for Searching by word in a string with word breakers
How to show first row group by part id and compliance type based on priorities of Document type?
Query to list all the databases that have a specific user
T-sql query to find the biggest table in a database with a clustered index