TABLE 1: Comparison of Jet, MSDE, and SQL Server
Features Jet MSDE Desktop SQL Server SQL Server (and Enterprise version)
Operating systems 9x/NT/2000 9x/NT/2000 9x/NT/2000 NT/2000
Maximum database size 2GB 2GB terabytes terabytes
Maximum number of processors 1 2 2 4 or 32*
Upgrade to server or enterprise version of SQL Server Upsizing Wizard with manual verification Attach database to SQL Server Attach database to SQL Server or enterprise version of SQL Server Already server or enterprise version
Integrated Windows NT/2000 security No Yes Yes Yes
Available with Office 2000 or Visual Studio 6.0 Yes Yes No No
Client Access License required? No No Yes Yes
*4 for SQL Server and 32 for Enterprise SQL Server