question

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.

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.

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.