A.3.2 Using a Microsoft SQL Server
If the data amount exceeds 1GB, using a Microsoft SQL server is an option. This
is only realized in the scope of a project including the Professional Services
Organization. Over the course of the project the data amount is to be estimated
and a corresponding scenario designed. Possible scenarios are:
• OpenScape Xpressions server and Microsoft SQL server parallel on one
computer
• OpenScape Xpressions server and Microsoft SQL server on an individual
computer each
In both cases the customer needs to provide the required licenses (among others
Microsoft SQL Server and if necessary Windows Server 2003 respectively 2008)
as well as the required hardware. If both servers are operated parallel on one
computer, this computer's hardware is to be measured accordingly.
With a Microsoft SQL Server you can manage very large amounts of data.
Besides the actual SQL Server the packet includes a number of management and
analysis tools.
You can obtain Microsoft SQL server setup details from the corresponding
product documentation or from the product homepage under http://
[URL unfurl="true"]www.microsoft.com/sql/.[/URL] Details for connecting the Report APL to the Microsoft
SQL Server are coordinated in the project scope.
IMPORTANT: Microsoft SQL Server 2005 does not recognize the data type
datetime. For a patch see
[URL unfurl="true"]http://www.microsoft.com/downloads/details.aspx?FamilyId=A7C903FE-35A7-[/URL]
4BB2-8E73.