January 31, 2007 at 5:12 pm
Hello,
I have SQL Server 2005 Express Edition installed on my computer and want to install SQL Server 2005 Standard Edition (just a local copy for learning purposes), but I'm not sure how to go about it. Could someone give me the steps to do this? Does it involve uninstalling the Express edition first? If so, which components do I need to uninstall, and is there any order to the uninstall?
I think once the Express edition is uninstalled, I can do the installation of the Standard edition. But if there are any special gotchas for that part, I'd be grateful for any tips on that part as well.
Thanks!
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
January 31, 2007 at 7:27 pm
Actually you can run the 2 in parallel. If you installed Express as the default instance, set up Standard as a named instance. If Express is a named instance, you can either set Standard as the default or named. Once that is established, you shouldn't have any problems.
That being said, if you actually want to get rid of Express, just run the Uninstall routine for the SQL Server service from Add/Remove Programs. It will subsequently uninstall most of the periphery that comes with it. Then you can install the Standard version.
hth
Tim
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
January 31, 2007 at 7:40 pm
Tim,
Thanks for your help!
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply