DNA User Guide › File Menu › Execute Batch File › SQL Server Types

SQL Server Types

You can implement CA RCM databases on Microsoft SQL Server or Oracle Server. In batch files that address the database server, you set the following command attributes to specify the type of database server and the target on the database server:

SQL_SERVER_TYPE

(Optional) Specifies what type of database server hosts CA RCM databases. The default server for batch processes is Microsoft SQL Server. Use this attribute only when an Oracle server hosts CA RCM databases. Any string value other than uppercase ORACLE specifies Microsoft SQL Server.

Valid values: ORACLE

Note: This attribute corresponds to the SQL Server Type field in the Data Management Settings dialog of CA RCM client applications (File, General Settings, SQL Connectivity).

SERVER

Defines the target on the database server:

• For a Microsoft SQL Server, this field specifies the host name of the database server instance.
• For an Oracle database server, this field specifies the net service name, as defined in the tnsnames.ora file in the Oracle service directory.

  Note: This attribute corresponds to the Server field in the Data Management Settings dialog of CA RCM client applications (File, General Settings, SQL Connectivity).

Examples: Connect to Microsoft SQL Server and Oracle Server

The following file references the CA RCM database on a Microsoft SQL Server. The Server attribute contains the host name of the server. The Database attribute is required.

<BATCH>
<COMMAND CONTINUE_ON_FAIL="true"
ACTION="IMPORT SQL"

SERVER="MSSQL_hostname"
DATABASE="eurekify_sdb"
SRC_FILE="SQL://BaseConfigModel.cfg"
DEST_FILE="OUTPUT/BaseConfigModel.cfg"/>

</BATCH>

The following file references the CA RCM database on an Oracle Server. The Server attribute contains the Oracle service name. The Database attribute is not used.

<BATCH>
<COMMAND CONTINUE_ON_FAIL="true"
ACTION="IMPORT SQL"

SQL_SERVER_TYPE="ORACLE"
SERVER="RCM_DB_service"
USER="sdb_admin"
PASSWORD="password"
SRC_FILE="SQL://BaseConfigModel.cfg"
DEST_FILE="C:\SBT\IMPORT_ORACLE\NewConf.cfg"/>

</BATCH>