Implementation Guide › Installing the Enterprise Management Server › How to Prepare the Enterprise Management Server › Prepare the Central Database for Enterprise Management › Central Database Script Deployment Examples

Central Database Script Deployment Examples

Deploying the script populates the central database and prepares it for the CA ControlMinder Enterprise Management installation. You deploy the script using the native database tools.

Example: Deploy the CA ControlMinder Oracle Deployment Script on Oracle Database 10g

This example shows you how to deploy the CA ControlMinder Oracle deployment on an Oracle Database 10g.

1. Click Start, All Programs, Oracle - ORACLE_HOME, Application Development, SQL Plus.

   The Oracle SQL*PLUS window opens.

2. Connect to the Oracle database using the user you created earlier.
3. Enter the full pathname to the script file preceded by the @ sign. For example:

   @C:\ temp_directory\oracle_database_deployment_script.sql
   

   Oracle deploys the script to the database.

Example: Deploy the CA ControlMinder Microsoft SQL Server Deployment Script on SQL Server 2005

This example shows you how to deploy the CA ControlMinder Microsoft SQL Server deployment on a SQL Server 2005.

1. Click Start, All Programs, Microsoft SQL Server 2005, SQL Server Management Studio.

   A login window appears.

2. Log in as a system administrator.

   The Microsoft SQL Server Management Studio opens.

3. Click File, Open, File.

   The Open File dialog appears.

4. Browse for and select the CA ControlMinder Microsoft SQL Server deployment script, and click Open.
5. From the Available Databases drop-down list, select the database that you created earlier to deploy the script on.
6. Click Execute to deploy the script.

   Microsoft SQL Server deploys the script to the database.