Hi Ron,
My sites usually end up running on SQL Server, so when I ca't develop
directly in SQL Server, developing in MSDE makes sense to me. I run MSDE on
Windows NT Workstation 4.0 at work, and on Win2k Pro at home.
The short answer:
MSDE appears to the developer exactly like SQL Server. It does not come
with SQL Enterprise Manager, so you'll either have to get a copy of that, or
use MSAccess 2000 as the front end. Using Access, you'll set up a Project
that connects to the MSDE engine. The nice thing about using Access is you
have the query by example tools, making query development very easy.
MSDE, like SQL Server, requires more planning than an Access database.
There are more security options, and you have a larger number of datatypes,
etc. For simple, small web sites that don't generate much traffic, Access
is usually OK. I've written intranets using Access that are hit by 10 - 15
users without problems. Remember that these are not 'concurrent' accesses -
simply concurrent users.
One nice thing about MSAccess is that it's very portable; as long as you can
set up an ODBC source to it, you can use it (on a Win box, of course).
However, Access is not a prime-time database, so for anything requiring
multiple concurrent access or any kind of load, don't use it unless you have
no other choice. If you have to interact with any third-party data sources,
applications or other DBs (ex: replication with a SQL Server), don't use
Access - it's going to be very slow and will put a much heavier load on the
remote server. We always use MSDE for this IF the client doesn't have SQL
Server or another client-server RDBMS.
Hope this helps!
Jeff
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 20, 2000 8:09 PM
To: CF-Talk
Subject: MSDE on Win2K... anyone successfully install it?
Just curious... anyone out there successfully running MSDE on Win2K?
If so, pros and cons vs. MSAccess for relatively low-volume sites? Ease of
administration? Installation?
thx,
Ron
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
