> For the complete documentation index, see [llms.txt](https://learn.capstorm.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learn.capstorm.com/copystorm-restore/reference/global-parameters-tab/tracker-database-parameters.md).

# Tracker Database Parameters

Parameters that determine the underlying database CopyStorm/Restore will use as its Tracker Database. This database allows CopyStorm/Restore to continue a restore if interrupted, and allows [incremental restoration](/copystorm-restore/common-tasks/incrementally-add-records-to-a-sandbox.md).

| Supported Databases |
| ------------------- |
| H2 (**Default**)    |
| PostgreSQL          |
| MySQL               |
| Snowflake           |
| SQL Server          |
| Oracle              |

## H2

![](https://2924009365-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5FyPmqVkPxhj2oT8fbgB%2Fuploads%2Fgit-blob-25f132249b36a93b359b2ab9e3a2b372798da176%2Fedd6024a-Restore-Tracker-Database-Parameters.png?alt=media)

| Parameter             | Description                                                                                                                                                                                                                                                                         |
| --------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Tracker Database Name | By default CopyStorm/Restore will pick a tracker name unique to the current configuration file, but it can be explicitly set using this global parameter. Note: CopyStorm/Restore tracking databases are, by default, kept in the directory “$HOME/.capstorm/copyStormRestoreSets”. |
| Use H2 in Server Mode | When checked, allows the H2 Tracker Database to operate in server mode, enabling support for multiple simultaneous connections.                                                                                                                                                     |

## PostgreSQL

![](https://2924009365-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5FyPmqVkPxhj2oT8fbgB%2Fuploads%2Fgit-blob-322984df599827957df116edc67f7eabfe061b52%2F6fd940a7-Postgres-TrackerParams.png?alt=media)

| **Parameter**             | **Description**                                                                                      |
| ------------------------- | ---------------------------------------------------------------------------------------------------- |
| Connection String         | A PostgreSQL connection string for connecting to the tracker database.                               |
| Connection String Builder | Clicking on this button launches a dialog menu that helps create a valid connection string.          |
| Username                  | Database username.                                                                                   |
| Password                  | Database password.                                                                                   |
| Schema (optional)         | The Database Schema where CopyStorm will house the Tracker data. If left blank, defaults to “PUBLIC” |

## MySQL

![](https://2924009365-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5FyPmqVkPxhj2oT8fbgB%2Fuploads%2Fgit-blob-7346d2feaa780f4986b052383cc034b6122f7146%2F4c5138fe-MYSQL-2.png?alt=media)

| **Parameter**             | **Description**                                                                        |
| ------------------------- | -------------------------------------------------------------------------------------- |
| Connection String         | A MySQL connection string for connecting to the tracker database.                      |
| Connection String Builder | Clicking on this button launches a dialog that helps create a valid connection string. |
| Username                  | Database username.                                                                     |
| Password                  | Database password.                                                                     |

## Snowflake

![](https://2924009365-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5FyPmqVkPxhj2oT8fbgB%2Fuploads%2Fgit-blob-3befcb6a8fc0ee23b26f52241e9f1b58777e1455%2F3a96a973-Snowflake.png?alt=media)

| **Parameter**             | **Description**                                                                                                                                                                                                                                                                                |
| ------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Connection String         | A Snowflake connection string for connecting to the tracker database.                                                                                                                                                                                                                          |
| Connection String Builder | Clicking on this button launches a dialog that helps create a valid connection string. More information on the Snowflake Connection String Builder can be found on the [Snowflake Connection Learn page](https://learn.capstorm.com/copystorm/readme/reference/main-tab/snowflake-connection). |
| Username                  | Database username.                                                                                                                                                                                                                                                                             |
| Password                  | Database password.                                                                                                                                                                                                                                                                             |
| Schema (optional)         | The Database Schema where CopyStorm will house the Tracker data. If left blank, defaults to “PUBLIC”.                                                                                                                                                                                          |

## SQL Server

![](https://2924009365-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5FyPmqVkPxhj2oT8fbgB%2Fuploads%2Fgit-blob-7dd1e58376bfac47857a4d7b5514cef94a7202bb%2F10ea2096-SQLServer-TrackerParams.png?alt=media)

| **Parameter**             | **Description**                                                                             |
| ------------------------- | ------------------------------------------------------------------------------------------- |
| Connection String         | A SQL Server connection string for connecting to the tracker database.                      |
| Connection String Builder | Clicking on this button launches a dialog menu that helps create a valid connection string. |
| Username                  | Database username.                                                                          |
| Password                  | Database password.                                                                          |

## Oracle

![](https://2924009365-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5FyPmqVkPxhj2oT8fbgB%2Fuploads%2Fgit-blob-06313292ad86b3da89c72faa0546b9e29893999d%2F89cecf87-Oracle-TrackerParams.png?alt=media)

| **Parameter**             | **Description**                                                                                       |
| ------------------------- | ----------------------------------------------------------------------------------------------------- |
| Connection String         | An Oracle connection string for connecting to the tracker database.                                   |
| Connection String Builder | Clicking on this button launches a dialog menu that helps create a valid connection string.           |
| Username                  | Database username.                                                                                    |
| Password                  | Database password.                                                                                    |
| Schema (optional)         | The Database Schema where CopyStorm will house the Tracker data. If left blank, defaults to “PUBLIC”. |

## Additional Info

* [Initial Setup Information](https://learn.capstorm.com/copystorm/readme/reference/main-tab/postgresql-connection)
* [PostgreSQL Best Practices](https://learn.capstorm.com/copystorm/readme/best-practices/postgresql-setup)