Date: Thu, 28 Mar 2024 17:10:22 +0000 (UTC) Message-ID: <1445305563.8989.1711645822202@catch-kbase-p> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8988_1356122986.1711645822200" ------=_Part_8988_1356122986.1711645822200 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
To change which database is being targeted, the web.config file = must be edited, and at a minimum there are 3 options which must be changed = to support each database engine - as per the table below:
Database Product | Migrator Provider | NHibernate Driver | NHibernate Dialect |
---|---|---|---|
MySQL |
Migrator.Providers.Mysql.MysqlDialect |
NHibernate.Driver.MySqlDataDriver |
EnterpriseTester.Core.Dialects.MySqlDialectEx= , EnterpriseTester.Core |
PostgreSQL |
Migrator.Providers.PostgreSQL.PostgreSQL82Dia= lect |
NHibernate.Driver.NpgsqlDriver |
NHibernate.Dialect.PostgreSQL82Dialect |
SQLServer 2012 (and above) |
Migrator.Providers.SqlServer.SqlServer2005Dia= lect |
NHibernate.Driver.SqlClientDriver |
NHibernate.Dialect.MsSql2005Dialect |
Enterprise Tester supports unicode strings in MySql databases, but you m= ust ensure some steps are followed during initial setup.
When creating the database, you must specify UTF8 as the default charact= er set and utf8 case insensitive as the default collation:
CREATE DATABASE `enterprisetester` CHARACTER SET utf8 COLLATE utf8= _general_ci;
If your connection string to the MySql database is:
<add= name=3D"Default" connectionString=3D"Server=3D10.1.1.1;Database=3Denterpri= setester;Uid=3Detuser;Pwd=3Detpass" />
Then you must append the UTF8 character set declaration to end, like so:=
<add= name=3D"Default" connectionString=3D"Server=3D10.1.1.1;Database=3Denterpri= setester;Uid=3Detuser;Pwd=3Detpass;CharSet=3Dutf8;" />
If you hav= e not set the UTF8 character set, there are ways to change the character se= t through a process of dumping out the database, performing a search/replac= e of all character set / collation declarations, then importing the modifie= d database dump. Please consult your in-house MySql DBA for assistance.
PostgreSQL
Enterprise Tester supports unicode strings in Postgresql databases, but = you must ensure some steps are followed during initial setup of the databas= e. Before beginning, make sure you have a version of PostgreSQL that s= upports a column type of "uuid" (normally version 8.3 and later) as this is= required by Enterprise Tester.
PostgreSql Databases must be created with a unicode encoding and we reco= mmend using "UTF-8". If you use a non-unicode encoding such as WIN1252 Ente= rprise Tester will still work, but you may experience some issues when rest= oring baselines from other ET instances, importing data or when users save = textual data that contains unicode characters.
For Postgresql to support unicode strings, you must create the database = with the 'UTF8' encoding, like so:
CREATE = DATABASE "enterprisetester"=20 WITH OWNER "postgres"=20 ENCODING 'UTF8'=20 LC_COLLATE =3D 'en_US.UTF-8'=20 LC_CTYPE =3D 'en_US.UTF-8';
Unlike MySql there is no need to change the connection string to accommo=
date UTF8 encoding. If you wish to learn more about setting the locale=
and collation for a PostgreSql database, please refer to the PostgreSql do=
cumentation:
http://w=
ww.postgresql.org/docs/current/interactive/locale.html
http://www.postgresql.org/docs/current/inter=
active/collation.
Example Connection Strings
Each database also uses a slightly different connection string format - = the http://connectionstrings.com/ website provid= es useful details of each connection string format.
Database Product | Example Connection String |
---|---|
PostgreSQL |
Host=3D192.168.1.232;Port=3D5432;Database=3De= test;UserId=3Dpostgres;Password=3DPassword123;Timeout=3D60;CommandTimeout= =3D120; |
SQL Server Express (user-attached database)= p> |
DataSource=3D.\SQLExpress;AttachDbFilename=3D= C:\ProgramFiles(x86)\CatchLimited\EnterpriseTests\Data\EnterpriseTester.mdf= ;InitialCatalog=3DEnterpriseTester;Trusted_Connection=3DYes; |
SQL Server (Integrated Security) |
DataSource=3D.\SQLExpress;Initial Catalog=3DE= nterpriseTester;IntegratedSecurity=3DTrue; |
SQL Server (SQL username/password) |
DataSource=3Ddbserver;Initial Catalog=3DEnter= priseTester;UserId=3Detuser;Password=3Detpass; |
Configuring a PostgreSQL Database
<= span class=3D"aui-icon aui-icon-small aui-iconfont-info confluence-informat= ion-macro-icon">Before beginning, make sure you have a version of PostgreSQL that suppor= ts a column type of "uuid" (normally version 8.3 and later) as this is requ= ired by Enterprise Tester.