(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