Categories
DBA

Upgrading SQL 2005 Evaluation to Enterprise Edition Without Uninstalling

Can we upgrade SQL 2005 Evaluation edition to SQL 2005 Enterprise edition without uninstalling the evaluation edition? This seems to be lingering in the minds of many DBA and hence I thought of explaining it in simple terms. Yes it is possible to perform the operation without uninstalling Trial edition of SQL 2005 prior to the end of the 180-day period.

There are two methods of performing the upgrade namely,

Directly running the setup

Using command prompt

Let me explain each of those in detail.

Directly running the Setup:

Step1: I have installed SQL 2005 Evaluation edition (180 days valid). Created a database Deepak and a table named detail in that database and inserted a record into that table.

Step2: The below screenshot shows the contents present in the table and the edition of SQL server before upgrading. Let us see if it gets reflected after upgrading to Enterprise edition

upg2ent1

Step3: Now go to the folder which contains the SQL server setup.exe of the Enterprise edition and run the setup. The screenshots for each of the option is shown below,

upg2ent2

upg2ent3

I have chosen only the SQL Server database services to upgrade to Enterprise edition. We can also choose the remaining services to upgrade if needed.

upg2ent4

The Evaluation edition already installed was a Default instance and hence I have chosen the same to upgrade to Enterprise edition.

upg2ent5

If you click the Installed instances tab in the above screenshot it will display the details of it as shown below.

upg2ent6

Click ok and then click Next it will show the existing components as shown below.

upg2ent7

If you click Details tab it will show as in the below screenshot.

upg2ent8

Next you need to provide the login information. I have chosen mixed mode authentication as shown below,

upg2ent9

upg2ent10

Click Install as shown in the above figure and once installation is completed the server is upgraded to Enterprise Edition.

Step4: We can verify whether the SQL server 2005 Evaluation edition is upgraded to SQL 2005 Enterprise edition without uninstalling Evaluation edition, as shown in the below screenshot. The datas are also available as the database is also upgraded. We can see the same table present and also the data which was present in evaluation edition.

upg2ent11

Using Command Prompt:

This is the most convenient method and you need to perform the below steps,

Step1: Perform the Step1 and Step2 as mentioned in the Directly running the setup

Step2: Go to command prompt and go to the folder containing SQL server 2005 Enterprise edition and type the below command and execute it.

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

upg2ent12

By Deepak

Microsoft Most Valuable Professional (MVP) award-winning Database Designer with 5 years of experience in designing, administering, developing & performance tuning relational databases and data warehouse.

I possess strong leadership skills experience by serving as the Chapter Leader of Professional Association for SQL Server (PASS) which has around 50 members.

I am passionate about solving business problems using my technical skills and hence I am interested in the field of Technology Consulting in Information Management.

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

*