With the release of SQL Server 2005, Microsoft has introduced the Express edition and the Workgroup edition to better meet the needs of each customer. The new line of SQL Server 2005 editions includes Express, Workgroup, Standard, and Enterprise Edition. The four new editions will offer a range of features including high availability, scalability, and business intelligence tools. The following table lists the various features in each edition:
| Express | Workgroup | Standard | Enterprise | |
|---|---|---|---|---|
| Number of CPUs | 1 | 2 | 4 | No Limit |
| RAM | 1 GB | 3 GB | No Limit | No Limit |
| Database Size | 4 GB | No Limit | No Limit | No Limit |
| Merge Replication | ✓ | ✓ | ✓ | ✓ |
| Transactional Replication | ✓ | ✓ | ✓ | ✓ |
| Report Server | ✓ | ✓ | ✓ | ✓ |
| Management Studio | ✓ | ✓ | ✓ | |
| Report Builder | ✓ | ✓ | ✓ | |
| Backup Log-shipping | ✓ | ✓ | ✓ | |
| Full Text Search | ✓ | ✓ | ✓ | |
| SQL Agent Job Scheduling | ✓ | ✓ | ✓ | |
| Database Mirroring | ✓ | ✓ | ||
| Failover Clustering | ✓ | ✓ | ||
| Notification Services | ✓ | ✓ | ||
| Integration Services | ✓ | ✓ | ||
| Web Services (HTTP Endpoints) | ✓ | ✓ | ||
| Analysis Services | ✓ | ✓ | ||
| Data Mining | ✓ | ✓ | ||
| Database Tuning Advisor | ✓ | ✓ | ||
| Advanced Performance Tuning | ✓ |
Read more about SQL Server 2005 editions and features…
Beekeeper Studio Es Una GUI de Base de Datos Gratuita y de Código Abierto
La mejor herramienta de consultas y editor SQL que he usado. Proporciona todo lo que necesito para gestionar mi base de datos. - ⭐⭐⭐⭐⭐ Mit
Beekeeper Studio es rápido, intuitivo y fácil de usar. Beekeeper soporta muchas bases de datos y funciona muy bien en Windows, Mac y Linux.
Lo Que Dicen Los Usuarios Sobre Beekeeper Studio
★★★★★
"Beekeeper Studio reemplazó por completo mi antiguo flujo de trabajo con SQL. Es rápido, intuitivo y hace que trabajar con bases de datos sea agradable de nuevo."
★★★★★
"He probado muchas GUIs de bases de datos, pero Beekeeper logra el equilibrio perfecto entre características y simplicidad. Simplemente funciona."