Database Guide › Database Storage and Partitioning › Run the DDL Scripts › Run the SQL Server Scripts

Run the SQL Server Scripts

You run the SQL Server scripts using the OSQL utility.

For each generated script, you must run an OSQL command. You must run these commands while connecting to the database as the ‘CA DLP database user’, that is, the account that CA DLP will use to access the CMS database.

1. Create a database to host the tables.
2. Create the database user account or accounts needed to install CA DLP.

   Ensure that all necessary privileges and roles are assigned to these accounts.

3. From a command prompt, go to the folder containing the Native*.sql scripts.
4. For each script, run an OSQL command. An example is shown below:

   OSQL ‑U sa ‑P password ‑d WGN 
     ‑i NativeCreateTables.sql ‑o NativeCreateTables.log
   

   Where:

   -U

   Specifies the SQL Server login for CA DLP.

   -P

   Specifies the password for the SQL Server login.

   -d

   Specifies the database name for the CA DLP database.

   -i

   Specifies the SQL script.

   -o

   Specifies the output log file.

   Note: Parameters are case-sensitive.

5. After these scripts have run, use SQL Server Enterprise Manager to verify that the CA DLP schema has been created and exists in the appropriate file groups.
6. This completes the script installation. You now need to install your CMS.

More information:

Install the CMS

SQL Server Logins