Hi all,
I just installed my VS 2005 Pro (full installation) and it installed Sql Server Express 2005. I also have a CD for Sql Server 2005 Developer Edition which I have not installed yet. My need for Sql Server on my development machine is for building and testing apps - just myself - no users will be hitting my sql server on my PC. Most of the time I hit my web server's sql server but also want the engine on my PC for when I'm offline.
Question: Should I install the developer edition and remove sql server express? Doesn't the developer edition more closely emulate the full-blown sql server, just that it only allows one or a few users to hit for development and testing purposes? At the same time, sql server express is scalled back in that it doesn't have all the goodies?
Thanks!
Stewart
![]() |
0 |
![]() |
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
I think I found my answer at the above link. Develper edition is just like enterprise edition and because I am not deploying it and I'm using
it myself, it should provide full sql server 2005 functionality whereas express does not in several categories (see chart on the linked page).I'll rely on the already deployed sql servers on the web host servers for deployment purposes.
Other comments welcome.
Thanks!
Stewart
![]() |
0 |
![]() |
You leave the Express alone and just add the Developer edition because it comes with two Management Studios one for the Algebra end as Express and there is a second one for the Caculus end called BI(business intelligence) Management Studio, if you know DTS(data transformation services) the new version called Integration Services is also there, Broker Services, Notification Services and the most important, the Agent that is used to create all automation in SQL Server. So install the Developer edition, it is better to copy the contents to your hard drive before installation and remember not to answer Windows questions just answer those relevant to you. Hope this helps.
Kind regards,
Gift Peddie
![]() |
0 |
![]() |
Hi Caddre,
Thanks for your reply!
I understand that I can leave Express alone and add Developer edition but I'm not sure why you're recommending I leave Express installed...just to learn it and it's management tool also?Regards,
Stewart
![]() |
0 |
![]() |
CSpace:
Hi Caddre,
Thanks for your reply!
I understand that I can leave Express alone and add Developer edition but I'm not sure why you're recommending I leave Express installed...just to learn it and it's management tool also?Regards,
Stewart
The Developer is no deployment but you can do deployments with Express if you need to.
Kind regards,
Gift Peddie
![]() |
0 |
![]() |
Hi Caddre,
I understand that it's not for deployment. As I stated in original post, "My need for Sql Server on my development machine is for building and testing apps - just myself - no users will be hitting my sql server on my PC.". I was asking with respect to my development PC. I have separate web hosted sql server's available for deployment.
Thanks for clarifying.
Regards,
Stewart
![]() |
0 |
![]() |
Did you end up upgrading sql express edition to developer? I tried to upgrade and wish I wouldnt have. It has given me 3 days worth of grief and lost work...
![]() |
0 |
![]() |
wildone:
Did you end up upgrading sql express edition to developer? I tried to upgrade and wish I wouldnt have. It has given me 3 days worth of grief and lost work...I am sorry you should have posted at the first error because it is not an upgrade but a second instance install because Express is just the smallest edition, so copy the contents of your CD/DVD to your hard drive and run setup then named instance because the first in a box can be default or named all other must be named instance. The reason when SQL Server is upgrading it looks for the TDS(tabular data stream) number and Express and Developer are both 90 so setup gets confused and start asking you useless questions to abort the install and one main rule with all RDBMS(relational database management systems) install don't answer questions from with OS just answer those relevant to you. Post again if you still have question. Hope this helps.
Kind regards,
Gift Peddie
![]() |
0 |
![]() |
Hi,
Sorry so long to reply. I wasn't checking this thread anymore. I did not "upgrade" as you wrote. I installed developer edition and now have both running.
Basically, I did what Caddre was mentioning about the second instance.Regards
![]() |
0 |
![]() |