RE: Upgrade SQL Express to Enterprise

SSC Guru

Points: 323504

April 27, 2016 at 5:30 pm

there's no upgrade path for Express to non express versions; instead you need to backup all the databases, script out your logins, as well as anything server related...certificates, linked servers, etc.

then uninstall sql express, install the non express version, and restore the databases, and runt he script sot put those users and objects back.

it's actually good disaster recovery practice to have to do this.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!