SQL SERVER 2005的版本差异

每次采购SQL SERVER的时候, 我一直在问, SQL SERVER是否需要采购, 用EXPRESS版本是否可以满足我的需求, 我用到了多少企业版的功能, 事实上, 我经历的应用开发中, 还没有部署过MIRRORING, 没有处理过Partitioning, 也没有尝试有ONLINE REINDEXING的操作, 也没有用过操作4CPU的PC服务器.

SQL Server 2005 Enterprise

• Data Mirroring
• ETL (Extract, Transform, Load)
• Partitioning
• Parallel Index operations and Indexed Views
• Online Indexing and restore
• Analysis Services
• Oracle Replication
• Advanced Performance Tuning
• 32 CPU support and no limit on memory

SQL Server 2005 Standard

• Fail Over Clustering
• Replication publishing and subscription
• Web Services (HTTP)
• SQL Service Broker
• Basic Data Mirroring
• Basic ETL (Extract, Transform, Load)
• Basic Analysis Services, Data Mining and
• Data Warehousing
• Notification Service
• Database Tuning Advisor
• 64-bit native support
• 4 CPU supported and limit on memory

SQL Server 2005 Workgroup

• Backup Log shipping
• Full Text Search
• SQL Server Agent
• SQL Server Management Studio
• Books Online and Samples
• 64-bit WOW support
• No limit on database size
• 2 CPU and 3 GB Ram supported

SQL Server 2005 Express

• All programmability features such as T-SQL, ADO.NET,
• SQL Native Client, and .NET support.
• SQL Server Management Studio Express Edition
• Replication Subscription
• SQL Service Broker Client
• Data Encryption and Key Management
• Basic Import and Export
• Basic Reporting
• 1 CPU and 1 GB Ram supported
• 4 GB Limit on database size
• 64-bit WOW support
• User Instance (XCopy Deployment)*