question

GoutamKumarDas-0197 avatar image
0 Votes"
GoutamKumarDas-0197 asked MiaMiao-MSFT published

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.

sql-server-generalsql-server-transact-sql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
1 Vote"
ErlandSommarskog answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MiaMiao-MSFT avatar image
0 Votes"
MiaMiao-MSFT answered MiaMiao-MSFT published

Hi @GoutamKumarDas-0197,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MiaMiao-MSFT avatar image
0 Votes"
MiaMiao-MSFT answered

Hi @GoutamKumarDas-0197,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.