...
Code Block |
---|
<add name="Default" connectionString="Server=Server123;Database=EnterpriseTester;User ID=bob;Password=pass123;Trusted_Connection=False;" /> |
Oracle
Enterprise Tester ships with 2 different Oracle drivers. For new installations we would recommend using the Managed Oracle driver.
Managed Oracle Driver
Change Enterprise Tester to use these values:
migration.providerName: "Migrator.Providers.Oracle.OracleManagedDriverDialect"
connection.driver_class: "EnterpriseTester.Core.Dialects.OracleManagedDataClientDriver,EnterpriseTester.Common"
dialect: "NHibernate.Dialect.Oracle10gDialect"
And update the connection string to be like this:
Code Block |
---|
<add name="Default" connectionString="User ID=SYSTEM;Password=password;Data Source=192.168.1.10:1521/orcl"/>
|
Unmanaged Oracle Driver
Note | ||
---|---|---|
| ||
This topic is for customer who are using Oracle unmanaged drivers. Generally, this topic will be relevant to customers who are using an Oracle database where the original version of ET installed was 4.7 or early. New Installations of Enterprise Tester Enterprise Tester 4.8 and above supports managed ODP.Net drivers. No separate installation is required for managed ODP.Net drivers. We recommended using the managed drivers by all new Enterprise Tester customers who wish to connect to an Oracle database. For details on configuration settings required to be set in the web.config for the Oracle managed drivers please consult the "Database Configuration" topic. |
Configuring Enterprise Tester to use Unmanaged Oracle drivers requires some additional manual steps. These are outlined in the "Oracle Driver Installation (unmanaged)" section.
Enterprise Tester requires the following values within the web.config:
migration.providerName: "Migrator.Providers.Oracle.OracleDialect"
connection.driver_class: "NHibernate.Driver.OracleDataClientDriver"
dialect: "NHibernate.Dialect.Oracle10gDialect"
The connection string to be something like the below (this will rely on TNSNAmes)
Code Block |
---|
<add name="Default" connectionString="User ID=SYSTEM;Password=password;Data Source=192.168.1.10:1521/orcl"/> |
Alternatively, you can specify the connection details inline, like this:
Code Block |
---|
<add name="Default" connectionString="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.10)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ETPROD)));User Id=SYSTEM;Password=password;" /> |
For more examples of Oracle ODP.Net connection strings, please see: http://connectionstrings.com/oracle#p12
PostgreSql
Change Enterprise Tester to use these values:
...