TFS4JIRA Self-Hosted | How to start using FIREBIRD database
- Damian Kilkowski (Inactive) (Deactivated)
Analytics
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.
login to the Windows server / VM where TFS4JIRA Self-Hosted is installed.
go to the folder where TFS4JIRA is installed and open/edit web.config file (default location: C:\inetpub\wwwroot\tfs-jira-synchronizer)
in the web.config, please proceed with the following correction:
look for line: <add key="forceDbType" value="SyncProfileContextConnection" />
replace it with: <add key="forceDbType" value="SyncProfileContextEmbeddedFirebirdConnection" />
save web.config
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.
