Datasheet

Chapter 1: Welcome to SQL Server Integration Services
19
Editions of SQL Server
The available features in SSIS and SQL Server vary widely based on what edition of SQL Server you ’ re
using. As you can imagine, the more high - end the edition of SQL Server, the more features are available.
In order from high - end to low - end, the following SQL Server editions are available:
SQL Server Enterprise Edition: This edition of SQL Server is for large enterprises that need
higher availability and more advanced features in SQL Server and business intelligence. For
example, there is no limit on processors or RAM in this edition. You ’ re bound only by the
number of processors and amount of RAM that the OS can handle. Microsoft will also continue
to support Developer Edition, which lets developers develop SQL Server solutions at a much
reduced price.
SQL Server Standard Edition: This edition of SQL Server now has a lot more value than ever
before. For example, you can now create a highly available system in Standard Edition by using
clustering, database mirroring, and integrated 64 - bit support. These features were available only
in Enterprise Edition in SQL Server 2000 and caused many businesses to purchase Enterprise
Edition when Standard Edition was probably sufficient for them. Like Enterprise Edition in SQL
Server 2005, it also offers unlimited RAM. Thus, you can scale it as high as your physical
hardware and OS will allow. However, there is a cap of four processors with this edition.
SQL Server Workgroup Edition: This new edition is designed for small and medium - sized
businesses that need a database server with limited business intelligence and Reporting
Services. Workgroup Edition supports up to two processors with unlimited database size. In
SQL Server 2008 Workgroup Edition, the limit is 3 GB of RAM.
SQL Server 2008 Compact Edition: This version was formally called the Express Edition and is
the equivalent of Desktop Edition (MSDE) in SQL Server 2000 but with several enhancements.
For example, MSDE never offered any type of management tool, and this is now included. Also
included are the Import and Export Wizard, and a series of other enhancements. This remains a
free addition of SQL Server for small applications. It has a database size limit of 4 GB. Most
important, the query governor has been removed from this edition, allowing for more people to
query the instance at the same time.
As for SSIS, you ’ ll have to use at least the Standard Edition to receive the bulk of the SSIS features. In the
Express and Workgroup Editions, only the Import and Export Wizard is available to you. You ’ ll have to
upgrade to the Enterprise or Developer Edition to see some features in SSIS. For example, the following
advanced transformations are available only with the Enterprise Edition:
Analysis Services Partition Processing Destination
Analysis Services Dimension Processing Destination
Data Mining Training Destination
Data Mining Query Component
Fuzzy Grouping
Fuzzy Lookup
Term Extraction
Term Lookup
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
c01.indd 19c01.indd 19 8/28/08 12:01:22 PM8/28/08 12:01:22 PM