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 See Teratrax Database Manager |
✓ | ✓ | ✓ | |
| 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 Is A Free & Open Source Database GUI
Best SQL query & editor tool I have ever used. It provides everything I need to manage my database. - ⭐⭐⭐⭐⭐ Mit
Beekeeper Studio is fast, intuitive, and easy to use. Beekeeper supports loads of databases, and works great on Windows, Mac and Linux.
What Users Say About Beekeeper Studio
★★★★★
"Beekeeper Studio completely replaced my old SQL workflow. It's fast, intuitive, and makes database work enjoyable again."
★★★★★
"I've tried many database GUIs, but Beekeeper strikes the perfect balance between features and simplicity. It just works."