Here's a decent summary of the different SQL Server 2005 editions:
http://www.sqlservercentral.com/columnists/bknight/comparisonofsqlserver2005editions.asp
It appears to me that the most significant differences between these 2
editions is the number of CPUs they can utilize (2 vs. 4), and the amount of
memory they'll utilize (3GB vs. unlimited).
Jeff
"M Johnston" wrote in message
news:5135470@discussion.autodesk.com...
"M Johnston" wrote in message
news:5134388@discussion.autodesk.com...
How do I decide which version ('Edition') of SQL Server 2005 to use?
'Express' is too small, 'Enterprise' too big (and expensive).
Can't see much difference between 'Workgroup' and 'Standard'.
I've got 20 users, about 500,000 drawings, and I'm about to upgrade to
Inventor 11, which comes with Vault 5.
_________
"Irvin Hayes (AutoDesk)" wrote in message
news:5134562@discussion.autodesk.com...
If you are still using Vault 4 then you can not install SQL 2005.
Check your SQL license to verify you have the license that will allow you to
install SQL 2000 until you are ready to upgrade to SQL 2005.
After you get Vault 5, upgrade your Vault installation then you can upgrade
SQL 2000 to SQL 2005.
Irvin
------------------
As I said earlier in the post, I've not yet got any version of Vault at all.
I'm about to install it.
It's going to be Vault 5, on Windows2003 Server, with SQL 2005.
My main (A) question is ; -
How do I decide which version ('Edition') of SQL Server 2005 to use?
'Express' is too small, 'Enterprise' too big (and expensive).
Can't see much difference between 'Workgroup' and 'Standard'.
I'm specifying a server to put it on, and want to order SQL 2005 (Version
??) with it.
I've got 20 users, about 500,000 drawings, and I'm about to upgrade from
Inventor 10 to Inventor 11, which comes with Vault 5.
My next question (B) will be ; -
What order should I install things, some sources say SQL first, some say
'Data Management Server' (is that the same as 'Vault' ?) first.
M Johnston