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

Once you complete customizing the deployment script, you can deploy it to your database. Deploying the script populates the central database and prepares it for CA Access Control Enterprise Management installation. You deploy the script using the native database tools.

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

This example shows you how to deploy the CA Access Control 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\AC126_oracle_script.sql
   

   Oracle deploys the script to the database.

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

This example shows you how to deploy the CA Access Control 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 Access Control Microsoft SQL Server deployment script, and click Open.
5. From the Available Databases drop-down list, select the database you created earlier to deploy the script on.
6. Click Execute to deploy the script.

   Microsoft SQL Server deploys the script to the database.