hi
I need to work with sql server 2005, I need server and developer tools.
my database contain 2 million records, 20 tables and 30 users.
what version of sql server 2005 I need ?
+3
A:
First of all, you need to learn to write better subject lines. I've noticed this is a habit with you. It's why I downvoted.
SQL Server 2005 Express would work for you. SQL Server 2005 Developer Edition would be good for use by your developers, but cannot be used in production.
Why not use SQL Server 2008? Why start off in the past?
John Saunders
2009-05-07 10:45:13
+1 - right, why 2005 these days?? :-)
marc_s
2009-05-07 10:55:33
-1 for developer edition - it says 30 users. ;)
J. Steen
2009-05-07 11:45:05
Well, actually, -1 is a bit harsh. Resetting. But, still. Developer edition is not a valid suggestion other than for actual development. Which you would need to clarify, in that case. =)
J. Steen
2009-05-07 11:47:42
+1
A:
Express Edition
Without knowing the size of your data the Express Edition may not be what you require as it has the following limitations:
- 4Gb database size
- 1 CPU
- 1Gb RAM.
Developer Edition
Because you are going to have 30 users connecting to this instance, the Developer Edition will be in violation of the Microsoft EULA and you would more than likely need to purchase SQL Server 2005 Standard or Enterprise Edition.
You could however use the Developer edition on your workstation to design and develop the database that will then be deployed onto a Standard or Enterprise edition server.
Hope this helps.
Wayne
2009-05-07 11:40:39