| Author |
Topic |
|
Stephan
Starting Member
2 Posts |
 Posted - 2006-06-12 : 08:16:45
|
| Hi,What is the best way to upgrade a SQL SERVER 2005 EXPRESS to the STANDARD version? |
|
|
mikewa
Microsoft SQL Server Product Team
84 Posts |
Posted - 2006-06-24 : 12:50:28
|
| There isn't one "best" way, there are two ways, and which to use depends upon your desired outcome. The upgrade paths are 'in place' and 'side by side' and there are two primary factors to consider:- The Instance Name of your SQL installation- Whether you want to manually move and attach your databasesDuring an in place upgrade, the SQL Standard installation just replaces the SQL Express installation. All the databases just stay in place and are attached to Standard. The Instance Name of your SQL installation does not change. By default, SQL Express installs to an instance name of <computer name>\SQLEXPRESS and this will still be the instance name once it has been upgraded to Standard.If you don't want to keep the same instance name, you must do a side by side upgrade. You install a new instance of SQL Standard and give it a unique instance name or let it install as the default instance. Once Standard is installed, you must mannually detach your databases from your SQL Express instance, move them to the Data directory of the Standard installation and then manually attach the database to Standard. This task is not difficult, but if you have hundreds of databases, it will take some time.One thing to be aware of is dealing with Management Studio. If you have installed Management Studio Express onto your computer, you will need to uninstall it before upgrading if you want to use the full version of Managment Studio that comes with Standard. These two "flavors" of Managment Studio can not be installed together and having one installed prevents the other form being installed.Hope this helps.Regards,Mike WachalSQL ExpressThis posting is provided "AS IS" with no warranties, and confers no rights.Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm |
 |
|
|
microhard
Starting Member
1 Post |
Posted - 2007-03-12 : 13:00:31
|
| Hi,I am in this exact same situation. I had a question. After the upgrade is completed will the migrated databases no longer have the 4GB limit inherent with the Express Edition?Sincerely,Robert GilDirector of IT Support |
|
|
|
mikewa
Microsoft SQL Server Product Team
84 Posts |
Posted - 2007-03-12 : 13:37:17
|
| Right - The size limit is part of SQL Express, not the database itself. When you attach the database to a non-Express edition of SQL Server, whether by upgrading or even just moving the database, the size limit no longer applies.Regards,Mike WachalSQL ExpressThis posting is provided "AS IS" with no warranties, and confers no rights.Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm |
|
|
|
jordanoliver
Starting Member
1 Post |
Posted - 2007-08-31 : 20:48:04
|
| Is there anything else to be aware of such as getting everyone out of the db? Possibly detaching the db's first? I don't mind the name staying the same so that I can deal with. It seems that if you don't mind the name the same then the upgrade is real straight forward. And do you need to remove Express when your done? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-31 : 21:27:53
|
| If you do in place upgrading, you don't have express at the end. And don't have to detach db. |
|
|
|
josalrod
Starting Member
1 Post |
Posted - 2007-10-18 : 22:08:13
|
| I just ran the updgrade from SQL 2005 Express to Standard. When I checked the properties of the instance it is still showing the Express version. Why? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-20 : 00:12:41
|
| What do you get from 'select @@version'? |
|
|
|
jmw45
Starting Member
7 Posts |
Posted - 2007-11-03 : 17:03:51
|
| I have been trying to install 2005 standard on my VPS and I get a message that a newer version is already installed. I do have 2005 Express already installed but I would like to do a side by side install of 2005 Standard. How can I do that? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-03 : 20:30:11
|
| Use another instance name in installation. |
|
|
|
jmw45
Starting Member
7 Posts |
Posted - 2007-11-03 : 22:00:57
|
| It doesn't ask me anything like that. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-03 : 23:11:17
|
| Should ask if you want to install it as default or named instance. |
|
|
|
jmw45
Starting Member
7 Posts |
Posted - 2007-11-03 : 23:17:22
|
| I copied both SQL Server 2005 Standard CDs to my VPS and then tried to install it and all it said was it couldn't install it because there was a higher version already installed. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-04 : 00:08:48
|
| Never saw this, sounds like try to apply lower level of sp or fix. Can you post complete message? |
|
|
|
jmw45
Starting Member
7 Posts |
Posted - 2007-11-04 : 01:05:53
|
| I believe so. They are from my MS Action Pack. They have completly different files on them. |
|
|
|
jmw45
Starting Member
7 Posts |
Posted - 2007-11-04 : 01:12:06
|
| No I can't. I went ahead and uninstalled 2005 Express (that was a big chore), ANd now when I try to install 2005 STandard all it will install is the 2005 STandard CLient. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-04 : 01:54:01
|
| Did you get right cd? |
|
|
|
jmw45
Starting Member
7 Posts |
Posted - 2007-11-04 : 12:51:33
|
| I appreciate all of the help I received on this forum, however I found out there was really nothing anyone could help me with. I was finally informed by by VPS provider that I could not install SQL Server 2005 Standard on my VPS. The reason is because it is a VPS. So now I have reinstalled 2005 Express and will have to be satisfied with that unless I want to pay more per month to use a shared 2005 Enterprise or pay even more per month to have a dedicated server.(Edited by graz to remove spam) |
|
|
|
acapalaban
Starting Member
1 Post |
Posted - 2009-02-11 : 01:45:56
|
quote:
Originally posted by josalrod
I just ran the updgrade from SQL 2005 Express to Standard. When I checked the properties of the instance it is still showing the Express version. Why?
Have you fixed the problem? May I know how? I also have got the same problem with you, please let me know how to fix it. Thanks. |
|
|
|
ttam007
Starting Member
1 Post |
Posted - 2009-02-11 : 10:28:09
|
| I have WinXP SP3 with SQL 2005 Express with Advanced Services SP2 and SQL 2005 Standard SP2 installed side by side right now (1 instance each). I also have SQL 2008 Express with Advanced Services installed. I want to upgrade by SQL 2005 Express instance to SQL 2005 Standard instance. Everything I've tried to do so comes up with some error or reason why the install won't work. I've run SQL 2005 Standard with SKUUPGRADE=1 in command prompt, but that says that newer components are installed and won't upgrade SQL 2005 Express.I don't care if I lose these databases - I have scripts that can re-generate them completely. I then thought I would just uninstalled SQL 2005 Express, but the only thing I have in A/R Programs says "Microsoft SQL Server 2005". No indication of which edition.Is my only option to uninstall both SQL 2005 versions and then put SQL 2005 Standard back on? Will that work with SQL 2008 already installed or will I have to remove SQL 2008 also? Any help is appreciated.Matt |
|
|
|
|
upgrade 2005 EXPRESS to STANDARD