# How Does CopyStorm Handle Internal Schema Upgrades?

When a new version of CopyStorm is released, adjustments to the internal CopyStorm data model may be required. By default, CopyStorm automatically handles database version upgrades. To disable automatic schema upgrades, refer to the [documentation](https://learn.capstorm.com/reference/configuration-tab/database-schema).

## Schema Upgrade Notice Dialog

CopyStorm’s default behavior is to display a Schema Upgrade Notice dialog to the user:

![](https://4057376488-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsbSqfKw3vSfr8qwXao4j%2Fuploads%2Fgit-blob-5fc5d1ccc3a2b5e78dc7995405124775375bd50b%2Fe10c239e-CapStorm_SchemaUpgradeDialog.jpg?alt=media)

From this dialog, you can:

* View all pending schema upgrades.
* View specific details about a schema upgrade, including the underling SQL to be executed.
* Approve or Disapprove of the changes.
  * Approving the changes will cause CopyStorm to execute all upgrade SQL.
  * Disapproving the changes will cause CopyStorm to terminate.
  * ***Note:*** By default, CopyStorm automatically applies the upgrades.
* View the progress of the approved changes.

## Viewing Individual Upgrade Details

CopyStorm offers users the ability to view details about an individual internal schema upgrade.

Users have the ability to see:

* Schema Upgrade **Description**
  * High level information about the purpose of the upgrade.

![](https://4057376488-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsbSqfKw3vSfr8qwXao4j%2Fuploads%2Fgit-blob-a508857ae4ed2a4a0e4ca6c9ce40d5e1ccbc5d8d%2F4e6acf5d-CapStorm_SchemaUpgrade_ViewDetails.jpg?alt=media)

* **SQL**associated with the Schema Upgrade
  * This provides users with the ability to copy & run the SQL manually.
  * ***Note:*** For some upgrades, SQL can also be generated dynamically by CopyStorm. In these cases, it is not appropriate to run upgrade SQL manually. Please contact <support@capstorm.com> before proceeding to run any upgrade SQL manually.

![](https://4057376488-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsbSqfKw3vSfr8qwXao4j%2Fuploads%2Fgit-blob-afb57e016e227ad0f6c98f02ae62068b9ee94ae4%2F954fb919-CapStorm_SchemaUpgrade_SQL-1.jpg?alt=media)

\***Note**:\*The Schema Upgrade shown in the above screenshots are for an update to introduce support for off-database partitions. To learn more about how off-database partitions work, refer to the [documentation](https://learn.capstorm.com/reference/copystorm-medic/partition-editor/how-do-copystorm-partitions-work).

## What Happens When Changes Are Not Approved?

When Schema Upgrades are not approved, the following dialog will be shown:

![](https://4057376488-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsbSqfKw3vSfr8qwXao4j%2Fuploads%2Fgit-blob-800fd82d75eea1f78407f4c394d3617507ed2636%2F62bc1aac-CapStorm_CancelSchemaUpgradeDialog.jpg?alt=media)

From this point, users have the options to:

* **Exit**
  * Terminate the CopyStorm application
* **Cancel**
  * Return to the Schema Upgrade Notice Dialog


---

# 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/frequently-asked-questions/how-does-copystorm-work/how-does-copystorm-work-2.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.