Required versions of SQL

acsservice
acsservice used Ask the Experts™
on
I am moving an RMS database to a new server.  The old server has SQL 2000 Enterprise, on a Server 2003 SBS.  I now am deploying a 2003 Server (Standard) with SQL 2005 (Standard).  The largest database is 6.5 GB.  There are 8 total.  Do I need to acquire Enterprise licensing?
Will the RMS run just as well on MSDE?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx

MSDE (called express in SQL 2005) is not OK because single DB is limited to 4GB
Standard version will work well.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
>> Do I need to acquire Enterprise licensing?

Not required. You need Enterprise Licensing if you need any of the features listed below which are not in Standard.

http://www.microsoft.com/Sqlserver/2005/en/us/Compare-Features.aspx

Will the RMS run just as well on MSDE?

Database will run perfectly.
For your application to run properly, you need to make sure that the connection strings and other parameters are set correctly.

Hope this helps.

Author

Commented:
I split the points because the two answers came in within 1 minute apart.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial