---
title: "TFS4JIRA Self-Hosted | How to start using FIREBIRD database"
canonical: "https://support.appfire.com/space/SUPPORT/153452972/TFS4JIRA%20Self-Hosted%20%7C%20How%20to%20start%20using%20FIREBIRD%20database"
format: markdown
---
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](https://appfire.atlassian.net/wiki/pages/viewpage.action?pageId=148177926).

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.