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

Run the SQL Server Scripts

This procedure installs the main database tables for the CMS.

Run the SQL Server scripts using the OSQL utility. For each generated script, run an OSQL command while connecting to the database as the ‘CA DataMinder database user’. This is the account that CA DataMinder will use to access the CMS database.

Install the CMS database tables

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

   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 DataMinder.

   -P

   Specifies the password for the SQL Server login.

   -d

   Specifies the database name for the CA DataMinder 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 DataMinder schema has been created and exists in the appropriate file groups.
6. This completes the script installation. You now need to install your CMS.