SQL Server database support
This topics lists the supported versions of Microsoft SQL Server database and BMC recommendations for using the SQL Server database.
Supported databases
The following SQL Server databases are supported for use with
:- SQL Server 2005 Standard Edition
- SQL Server 2005 Enterprise Edition
- SQL Server 2008 Standard Edition
- SQL Server 2008 Enterprise Edition
- SQL Server 2008 R2 Enterprise Edition
BMC recommendations
recommends that you use the Enterprise Edition of SQL Server databases. While the product is designed to work with the Standard Edition of these databases, the Enterprise Edition offers the following benefits for data warehousing projects:- Better performance when handling large data volumes
- Use of partitioning for time-based data archival
Best practice recommendations for data warehousing also include the use of capabilities that are available in Enterprise Editions.
Other requirements
The following table shows the supported operating system and SQL Server database installation combinations. This table also includes the database client software requirements for the reports server:
Operating system and SQL Server combinations
Database | Platform support | Installation requirements | Tools required |
|---|---|---|---|
SQL Server | Microsoft Windows | Bulk Copy Program (BCP) is installed as part of the Client Tools installation. Running the SQL Server installer with the Connectivity Only option selected is not supported because it does not install BCP. | BCP |