SQLServer version selection

xiaoxiao2021-03-19  211

For those who have exposed the SQL database, there are many questions about the SQL version of these issues, but they are too lazy to study carefully. Although the problem is simple, it is not small.

Here are the simple contrast of these versions:

SQL Server includes Enterprise Edition, Standard Edition, Personal Edition, Development, Desktop Engine (MSDE), Evaluation, CE

1. The evaluation version is used for assessment, and the CE version is used for Windows CE, so there is not much to say

2. From the function, the Enterprise Edition and Development Edition is a pair, the standard version and the personal version are pair. Enterprise Edition and Development Edition is mainly used for large users, support more CPUs, memory, can support cluster, log shipping, parallel DBCC, parallel creation index, index view and other advanced features.

3. From the installation, Enterprise Edition and Standard Edition is a pair, personal version, development and desktop engine are a group, and the Enterprise Edition and Standard Edition can only be installed on Windows Server (NT, 2000, 2003). Personal veneration, development and desktop engine can be installed in more systems (including NT Workstation, 2000 Professional, XP, etc.98 can only install personal version or desktop engine, but desktop engines do not exceed 2G).

4. Use Enterprise Edition, Standard Edition or Desktop Engine, (Personal Edition, Development Edition).

SQL7.0 \ operating system

Win9x

NTW

NTS

NTSE

The desktop version can be available to the standard version can be available

转载请注明原文地址:https://www.9cbs.com/read-130109.html

New Post(0)