TFS4JIRA Self-Hosted | How to start using FIREBIRD database

Owned by Damian Kilkowski (Inactive) (Deactivated)
Oct 26, 2022
1 min read

By default, when TFS4JIRA Self-Hosted is installed, the SQL Compact Edition database is being used. TFS4JIRA has a native FIREBIRD support enabled. To force the TFS4JIRA application to start using the FIREBIRD database instead of the SQL CE database following steps must be followed.

Switching to a FIREBIRD database should not be done in cases when synchronization/migration has been setup and running for some time. When switched with the below instruction, setup of all synchronization profiles and check-ins configuration must be created. Especially in case of synchronization profiles, the outcome might result in duplicates and some data missing. Please reach Appfire support for more information: contact information page.

  1. login to the Windows server / VM where TFS4JIRA Self-Hosted is installed.

  2. go to the folder where TFS4JIRA is installed and open/edit web.config file (default location: C:\inetpub\wwwroot\tfs-jira-synchronizer)

  3. in the web.config, please proceed with the following correction:

    1. look for line: <add key="forceDbType" value="SyncProfileContextConnection" />

    2. replace it with: <add key="forceDbType" value="SyncProfileContextEmbeddedFirebirdConnection" />

  4. save web.config

  5. login to TFS4JIRA, you should see an empty list of profiles and no check-ins configuration, it means the database is now set to FIREBIRD.

Â