Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AmrineA
Starting Member
4 Posts |
 Posted - 2008-11-21 : 09:36:26
|
| This shouldn't be hard, but it appears to be difficult to find information on it. I have a server running SQL Server 2005 Developer Edition with SP2. I want the server to be running SQL Server 2005 Standard Edition with SP2. However, when you run the SQL Server 2005 Standard Edition install, it will not allow you to upgrade because the install is without SP2 and the Developer Edition has SP2. It gives some error saying you can't "upgrade" to an older version. So what is the proper steps to move from the Developer Edition to the Standard Edition. I'm starting to think that I need to uninstall SP2 and then upgrade to Standard Edition and then reinstall SP2. Does that sound right? Seems kind of ridiculous. Is there any harm in doing this? |
|
|
Carat
Yak Posting Veteran
92 Posts |
Posted - 2008-11-21 : 09:45:21
|
| I'm not sure this is possible. The Developer edition is exact the same as the Enterprise edition except that you can't use it in a production envrionment.Lets say that you use Partitioning in your Developer edition and you are trying to upgrade to the Standard edition, which does not support Partitioning. I think this would be a problem. |
 |
|
|
AmrineA
Starting Member
4 Posts |
Posted - 2008-11-21 : 09:57:51
|
| According to this site, it is possible. http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspxBut then according to this site, uninstalling SP2 is not possible. http://www.mssqltips.com/tip.asp?tip=1186We are running TFS against this SQL Server install and we originally started it on a trial basis. But now we have decided to purchase SQL Server and are upgrading our existing install and moving it to another server. We have purchased the SQL Server 2005 Standard license and CALs in hopes of using it on our new TFS Server. However, TFS is very specific about having to use the same version, language, and collation settings from one SQL Server box to the next. I had problems with the install the first time and I'm trying to figure out if it's the fact that the SQL Server Editions were not the same, or something else in the process. In order to eliminate SQL Server, I wanted to make them the same Edition. |
|
|
|
|
|
|
"Upgrade" Editions