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 |
|
PaTRiCKDRD
Yak Posting Veteran
55 Posts |
 Posted - 2008-10-03 : 03:07:25
|
| Hi everyone!I discovered yesterday that my server's sql server edition is developer one, which could be a cause for many of my .net web site crashes on the communication with the database,my questions are:1) Is it possible to install enterprise edition OVER developer edition WITHOUT unistalling (because my site is live)?2) If it is not, then, except the backup, what else should I take care to backup manually? One thing is jobs, anything else?Thanks in advance! |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-03 : 03:25:54
|
| Developer edition runs on windows workstation and enterprise runs on windows server |
 |
|
|
PaTRiCKDRD
Yak Posting Veteran
55 Posts |
Posted - 2008-10-03 : 04:27:41
|
| I know that,but my server is Windows Server 2003 and runs Developer Edition |
|
|
|
lepeniotis
Yak Posting Veteran
75 Posts |
Posted - 2008-10-03 : 07:04:38
|
| Run Upgrate advisor this is what microsoft suggest on the books!But I don't think that you will have a problem upgrating to enterprize edition! If you are ok with the licences.!!!!I think!!!MSc Advanced Computing Science MSc Database ProfessionalSheffield Hallam UniversityMCP (70-229, 70-228)Industrial IT Engineer |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-03 : 07:33:09
|
| Basically developer edition is optimized for a development work arena. It can support multiple databases and invariably do virtually everything the enterprise can do, but its not optimized as a server db. You can backup and restore or attach/detach.I would advice you install a NEW INSTANCE. You can have more than 1 instance running on your server. On our Remote server we have 2 instances, express 2005 and the other, we just upgraded to 2008.Doesnt take up to 1 hour of downtime and migration of dbs, at an obscure hour, when you have less traffic |
|
|
|
|
|
|
|
|
switching from developer ed to enterprise?