Versions Compared

Old Version 1

changes.mady.by.user Catch Admin

Saved on

compared with

New Version 2

changes.mady.by.user Catch Admin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: First published version

...

Database ProductMigrator ProviderNHibernate DriverNHibernate Dialect

MySQL

Migrator.Providers.Mysql.MysqlDialect

NHibernate.Driver.MySqlDataDriver

EnterpriseTester.Core.Dialects.MySqlDialectEx, EnterpriseTester.Core

Oracle 10g/11g (Unmanaged Driver)

Migrator.Providers.Oracle.OracleDialect

NHibernate.Driver.OracleDataClientDriver

NHibernate.Dialect.Oracle10gDialect

Oracle 10g/11g (Managed Driver) (info)Migrator.Providers.Oracle.OracleManagedDriverDialect

EnterpriseTester.Core.Dialects.OracleManagedDataClientDriver, EnterpriseTester.Common

NHibernate.Dialect.Oracle10gDialect 

PostgreSQL

Migrator.Providers.PostgreSQL.PostgreSQL82Dialect

NHibernate.Driver.NpgsqlDriver

NHibernate.Dialect.PostgreSQL82Dialect

SQLServer 2005 (and above)

Migrator.Providers.SqlServer.SqlServer2005Dialect

NHibernate.Driver.SqlClientDriver

EnterpriseTester.Common.NHibernate.Dialects.MsSql2005DialectEx, EnterpriseTester.Common

Note

If you are installing Enterprise Tester for the first time and using an Oracle Database we strongly suggest using the Managed Oracle Driver - as this will provide a much easier installation experience.

When using the managed driver you:

  • Do not need to install ODAC or any Oracle client packages on your ET server.
  • Do not need to add additional configuration sections to your web.config file.
  • Need less disk splace (Installing ODAC requires an additional 200mb or more of disk space for installation).
  • Can configure the application pool to either 32bit of 64bit without having to change the version of ODAC installed (such as if you wish to support importing .EAP files from Enterprise Architect, which requires the application pool be configured to support 32bit applications.
Info
titleOracle Managed Driver

When using the Oracle managed driver, you will also need to configure the following in the appsettings section of your web.config file:

<appsettings>
<add key="nhibernate.driver.oracle.enable-multiquery" value="true" />
...
<\appsettings>

...

Oracle Database Configuration Notes when using Windows Server 2008r2

Note

This instructions only apply when using the unmanaged Oracle driver, we strongly recommend for new customers that they instead use the managed oracle driver, which does not require installation of additional software (ODAC) on their ET server.


Enterprise Tester no longer ships with Oracle drivers. To use Enterprise Tester with an Oracle database you must download and install the Oracle ODP.Net drivers from the Oracle website (part of ODAC). You can install either 32bit: http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html or 64bit: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html. 

...