question

HrishikeshLele-1582 avatar image
0 Votes"
HrishikeshLele-1582 asked ·

Upgrade SQL Server Edition

Hello,
I want to upgrade my Sql server 2014 Express to Sql server 2014 Enterprise. I have the databases, user securities, log paths setup for my project using Express.
Are there any special precautions to be taken before upgrading the edition? Does upgrading editions affect the database design or user securities or any relevant configuration in any way?



Thanks,
Hrishikesh

sql-server-general
· 1
10 |1000 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.

Hi, we have not received a reply from you. Did the answers could help you?

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered ·

Hello,

You can upgrade the existing SQL Server instance directly in one go, only precaution I suggest is to backup all databases (incl. system DB) before.
The upgrade won't effect database design, permissions or anything else, you just get more features, like SQL Server Agent, SSIS, SSAS and SSRS.

See Upgrade to a Different Edition of SQL Server (Setup) for how to.


·
10 |1000 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.

Shashank-Singh avatar image
0 Votes"
Shashank-Singh answered ·

I have the databases, user securities, log paths setup for my project using Express.

You should follow in-place upgrade mechanism. Copy the SQL Server 2014 enterprise setup on current machine where SQL Server 2014 express is installed. Go to setup and run it as administrator, on page that pops up select maintenance on left side and then first option of edition upgrade on top right select options that follow up and SQL server will upgrade instance automatically keeping all the securities and logins same. Since the machine does not changes the path you have configured will not change.

·
10 |1000 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.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered ·

Hi @HrishikeshLele-1582,


Are there any special precautions to be taken before upgrading the edition?

As Olaf said, you need to back up all the databases (including system databases and user databases) before the upgrade. In case of anything happen.

D

oes upgrading editions affect the database design or user securities or any relevant configuration in any way?

No, the upgrade will not affect the database design or user securities or any relevant configuration.


Best regards,
Carrin

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


·
10 |1000 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.