Command Syntax Needed for Upgrade from SQL Express to SQL Developer

Question

Command Syntax Needed for Upgrade from SQL Express to SQL Developer

Sid Childers

Ten Centuries

Points: 1079
More actions
December 12, 2007 at 4:55 pm

#119291

Good Afternoon,
I installed SQL 2k5 express on my laptop and now want to upgrade it to the developer edition. It appears that this scenario is feasible, can someone confirm?
If feasible, what command line syntax should I use?
Thanks, in advance, for your help.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 1

I don't believe you can upgrade the instance. You can install Developer Edition as another instance or you can detach your databases, uninstall Express, and then install Developer.

All upgrades or installs use the SQL Server setup program that comes on the CD/DVD. Here's a KB article: http://technet.microsoft.com/en-us/library/ms144259.aspx

SQL_ABD SSCertifiable Points: 5832 More actions · Answer 2

Hi,

Check also the following link

http://msdn2.microsoft.com/en-us/library/ms143393.aspx

Regards,

Ahmed

Kevin Brennan Right there with Babe Points: 738 More actions · Answer 3

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

You can replace the /qb with /qn if you want a silent upgrade but then you will need to check the install logs for any errors. Of course it should go without saying that you need to backup all your databases first.

CodeMinkey

Sid Childers Ten Centuries Points: 1079 More actions · Answer 4

Thanks all for your input. When I run the command from the prompt, I receive a message Please go to control panel to configure system components.

Unforunately, when I go to control panel, I'm not sure which components to activate. Has anyone encountered this ambiguous error message?

Kevin Brennan Right there with Babe Points: 738 More actions · Answer 5

Ah well perhaps I should have added that you should first open your dos command window -> run -> CMD then from there navigate to the Drive then folder in which sql server setup.exe exits then issue the command.

The problem may be due to the fact that Windows is executing the setup.exe that it finds in your system path (i.e. the one in your system32 folder).

Alternatively

This is sometimes caused by an registry entry in:

HKLM/Software/Microsoft/Windows/CurrentVersion/App Paths/setup.exe

that ends up initiating setup.exe in Windows\System32. The setup.exe there

displays that message. Delete that registry entry. If only everyone stopped

calling their programs setup!

Also

This sometimes happens if there is a file named Autorun.inf in the drive's root directory.

If the Autorun.inf line reads the following, the first error message is displayed:

[autorun]

open=Setup.exe

C:\Windows\System32\Setup.exe is launched actually

If the Autorun.inf line reads the following, the second error message is displayed:

[autorun]

open=Filename.exe

(where the filename.exe file is missing)

CodeMinkey