|
Question:
What if I want to purchase the full Microsoft SQL Server?
Answer:
Express Technology software includes the Microsoft Database Engine
(MSDE2000) which is Microsoft SQL Server with two limitations: 1. It does
not include tools for managing and extending your database and 2. The
databases have a size limitation of 4 Gigabytes.
For
most clients, the two limitations do not present a problem. Four
gigabytes is a lot of data. However, you may wish to purchase the full version of Microsoft SQL
Server if you have a really large amount of maintenance data and equipment
with photos or you wish to create additional database tables and fields for other
uses. You can make the upgrade at anytime in the future.
Installing
- You can start with the MSDE and later upgrade to the full version of
Microsoft SQL Server. Upon installing SQL Server, the existing
database will be retained and completely functioning. For more
details on installing, see the
applicable tech bulletin.
Licensing -
If you
decide to purchase SQL Server, you must purchase a sufficient number of
client access licenses (cals) for the number of expected concurrent
users.
Version
- We recommend purchasing Microsoft SQL Sever 2000 Standard edition
which is the latest release. If you plan to do Enterprise wide web
interaction you might consider purchasing the Enterprise edition.
Visit
the MS SQL Server home page.
Operating
System - We recommend running SQL Server on Microsoft Windows XP Professional
Edition although it will run fine under NT and 2000 as well.. You might consider Windows
XP Server only if you
plan to do web hosting or terminal services. Windows 2000 Server
is substantially more expensive and you must then purchase client access
licenses as well. SQL Server run excellent under the Professional
Edition and client access licensing is not required.
Purchasing
- We have found excellent pricing on Microsoft
SQL Server from CDW. You can visit the
CDW website for more information.
Other
Sources Include:
www.microwarehouse.com
www.pcconnection.com
www.programmersparadise.com
www.directdeals.com
www.office-software.com
Click
here for more details at our site on Client / Server and MS SQL Server. |
