May 27, 2011 at 1:08 pm
Question, could you suggest a version of SQL server to install on my Windows 7 (x64) laptop? I want it mostly for development with visual studio dot net.
Could anyone suggest a version of SQL server to install on my Windows 7 (x64) laptop? I want it mostly for development with visual studio dot net.
I have the following versions of SQL Server 2008 R2 available for me to install …
•Express
•Express with advanced services
•Express with management tools
•Management studio express
•Developer
•Enterprise
•Standard
•Web
•Workgroup
•Datacenter
Would the "Developer" version be best? I want the version that will be best for development, without putting too much on my laptop.
May 27, 2011 at 2:44 pm
I don't know about 2008, but I'll speak to SQL Server 2005 and maybe someone can talk about 2008 specifically.
If it were me and my laptop could handle it (disk and memory) and I had an appropriate license that allows for it, I'd go with Developer Edition. The primary reason is because the Developer edition is specifically licensed for development purposes and is basically a pared-down version of Enterprise edition. If you have a development license that allows for it (e.g. MSDN subscription) then use Developer Edition -- it may already be included with your Visual Studio license too. The licensing has gotten pretty weird lately though, so you'll need to check on that.
Something else to consider...what version of SQL Server does your deployment environment have? If you use Developer Edition, you need to be careful to not accidentally build something that uses an Enterprise-level feature when your target deployment environment does not have SQL Server Enterprise. But even with that, I'd still go with Developer Edition.
As a final note, what version of Visual Studio will you use? Check online to see if there are any compatibility or other issues with using SQL Server 2008 with Visual Studio. v2005 seems to work just fine with Visual Studio 2010, but I'm not sure about 2008. There may be some features of SQL Server 2008 that don't work well (yet) with Visual Studio, but I don't think that has anything to do with which edition you install, and in fact 2008 might work better with latest version of Visual Studio, I don't know.
May 27, 2011 at 3:23 pm
I'd go with developer, it IS Enterprise Edition in every way that makes any difference. If works just fine with VS2008 and I've had no issues with VS2010. I would stay away from the express versions in development. If you were developing products that would be required to run on that version MAYBE but otherwise no.
Also, can I ask why you posted this in a SQL 7/2000 forum?
CEWII
May 27, 2011 at 4:11 pm
Thank you both for your reply's. It sounds like developer would be the route to go. Sorry about the Server 7 forum. I found a similar post, (that did not answer my question) and did not realize that it was a server 7 forum.
May 27, 2011 at 6:23 pm
No problem, have a good weekend..
CEWII
May 27, 2011 at 8:53 pm
Yes, Developer Edition is the way to go. It is about $50 from Amazon.com last time I checked, and it has the features of Enterprise Edition.
It also installs on a Workstation OS like Windows 7 or Vista, without requiring a Server version of Windows like the real Enterprise Edition does.
This edition has is not supposed to be used for any sort of production activity, only development. This restriction is a EULA restriction, not a technical one where the software itself actually restricts stuff.
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply