Do I need to use SQL server Enterprise or Standard edition

[EBECK]

The homeless shelter organizaiton I work for has an old Guest Registration system written using Access 97 VBA for our guests. We store their pictures outside the database, in another folder. There are about 10,000 Guest records in this system.

I'm developing a new Guest Registration system. In addition to the usual name, address, ... information I'm considering putting their picture (a .jpg file) on the Guest record. I'm wondering if I can easily accomplish this task (storing all of the guest information along with their picture in the Guest table) using SQL server Standard edition or if I should upgrade it to the SQL server Enterprise edition.

Do you have any feedback? Thank you in advance for your time and consideration.

Ed

 

[mrdenny]

Standard edition will work fine. I would recommend keeping the image outside of the database. SQL wasn't designed to have image files stored within the database. It's much more effecent to put the image in a folder and keep the path to the image in the database.

The only reason that you should considder upgradding to SQL Enterprise Edition are:
1. You need to access more than 2 GB of memory.
2. You need federated databases.
3. You need advanced cubing
4. You need more than 4 processors.

That's pretty much what Enterprise Edition offers.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[SonOfEmidec1100]

You may find the version of SQL server will be determined by the operating system being used.

http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp

 

[mrdenny]

I'm not sure what the OS will have to do with selecting between Standard and Enterprise. They both run on the same OSs.

Denny

--Anything is possible. All it takes is a little research. (Me)