# 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

![](/files/xW49qpmybSTcG71xqIUd)

| 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

![](/files/QOkg6t2WIxAESSMZy0du)

| **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

![](/files/uQ8Yj29NasGhMElNOnPF)

| **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

![](/files/F3wWDmd58s8CisN16R1r)

| **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

![](/files/SwTj4Ve3CkAyPd8sredZ)

| **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

![](/files/IjYzO5uhHi9Xb4pXOB3d)

| **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)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://learn.capstorm.com/copystorm-restore/reference/global-parameters-tab/tracker-database-parameters.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
