(Windows) DB Examples - Server Silent Install

This section contains examples of Windows options files configured for each of the databases (Derby, MySQL, Oracle, and MS SQL Server).

Derby Database optionsFile.txt example

         AgreeToLicense=Yes
         SRA_USER_INSTALLDIR=C:\Documents and Settings\Administrator\.serena\ra
         JMS_PORT=7918
         AGENT_MUTUAL_AUTH=Y
         TC_PORT=8080
         DB_TYPE=derby
         DERBY_PORT=11377
         DERBY_USER=serena_ra
         DERBY_PASSWORD=serena_ra

MySQL Database optionsFile.txt example

         AgreeToLicense=Yes
         SRA_USER_INSTALLDIR=C:\Documents and Settings\Administrator\.serena\ra
         JMS_PORT=7918
         AGENT_MUTUAL_AUTH=Y
         TC_PORT=8080
         DB_TYPE=mysql
         JDBC_DRIVER_SOURCE=c:\TestArea\libloc\mysql-connector-java-5.1.22-bin.jar
         MYSQL_JDBC_DRIVER=com.mysql.jdbc.Driver
         MYSQL_DB_CONN=jdbc:mysql://localhost:3306/serena_ra
         MYSQL_USER=serena_ra
         MYSQL_PASSWORD=serena_ra

Oracle Database optionsFile.txt example

         ...
         ...
         DB_TYPE=oracle
         JDBC_DRIVER_SOURCE=c:\TestArea\libloc\oracle-connector-java-5.1.22-bin.jar
         ORA_JDBC_DRIVER=oracle.jdbc.driver.OracleDriver
         ORA_DB_CONN=jdbc:oracle:thin:@localhost:1521/serena_ra
         ORA_DB_SCHEMA=serena_ra
         ORA_PASSWORD=serena_ra

SQL Server Database optionsFile.txt example

         ...
         DB_TYPE=sqlserver
         SQLSVR_JDBC_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
         SQLSVR_JDBC_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
         SQLSVR_DB_CONN=jdbc:sqlserver://localhost:1433;DatabaseName=serena_ra
         SQLSVR_USER=serena_ra
         SQLSVR_PASSWORD=serena_ra