Hey All -
I need to develop a database that will be approximately 100 MB in size
and will have approx 15 concurrent users. I am attempting to
understand what my Microsoft database options are. Clearly Access is
one. What about MSDE? Do I need to purchase a copy of SQL Server to
utilize the MSDE technology? If so, which edition/CALs do I need?
Thanks for helping this DB rookie out.
Dave
It sounds like MSDE would work fine for your needs, depending on how often
the 15 user hit the server. Here is a link to some information about the
appropriate uses for MSDE:
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
For a multi-user network client server application with a low number of
users MSDE is a very good choice. Purchasing a copy of SQL Server is not
necessary, although I would recommend buying the Developers Edition of SQL
Server ($50) for the development tools it provides and the ability to test
your application on SQL Server.
Personally, I wouldn't bother with Access as a backend data store.
Jim
"dave" <thorung@.mailcity.com> wrote in message
news:f9e0449e.0404201837.5eefeade@.posting.google.c om...
> Hey All -
> I need to develop a database that will be approximately 100 MB in size
> and will have approx 15 concurrent users. I am attempting to
> understand what my Microsoft database options are. Clearly Access is
> one. What about MSDE? Do I need to purchase a copy of SQL Server to
> utilize the MSDE technology? If so, which edition/CALs do I need?
> Thanks for helping this DB rookie out.
> Dave
Monday, March 19, 2012
MSDE newbie question
Labels:
approx,
approximately,
attempting,
concurrent,
database,
develop,
microsoft,
msde,
mysql,
newbie,
oracle,
server,
sizeand,
sql,
tounderstand,
users
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment