> For the complete documentation index, see [llms.txt](https://docs.infotopics.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.infotopics.com/writebackextreme/troubleshooting-and-faq/faq/how-to-copy-a-schema-to-another-database.md).

# How to copy a schema to another database

WriteBackExtreme does not support transferring a schema to another database. The best option is to copy the table using the export/import function via management console and transfer the data itself using your own database management tool. 

1. Open the management console.
2. Go to schemas and select the schema you want to copy
3. Click the export button at the top right. A json fill will be downloaded in your browser
4. Click Schemas in the menu again
5. Click the import button
6. Select the connection to the other database
7. Click import. The table will be created. 
8. After this, export all data from your original table with your favorite database management tool and import it to the new table in the destination database table. 

Since we made a copy, all dashboards need to be reconfigured using the new schema. 

The easiest way to do this is trough the export/import functionality of the extension. This way  your dashboard extension settings are preserved. 

1. In the management console, open the schema.
   1. The url looks like this: https\://\[your-writebackextreme-url]/backend/schemas/84f7d654-f672-4e16-91fa-3b3d4c58c64b/
   2. The last part (excluding the / at the end) is the UUID of the new schema. 
   3. Copy this UUID. 
2. In your dashboard extension go to configuration
3. Select import/Export in the left menu
4. Click Download data file
5. Open the file in a text editor like notepad.
6. Search for the term `schema_key` in the file. The value should be a UUID (for example 9ab26ae5-5e5f-4142-ba6a-b61ac77f7a23)
7. Change the original UUID to the new one you copied from the management console.
8. Save the file
9. Go to the dashboard configuration again
10. Remove the old schema.
11. Import the data.json file you just edited on the import/Export page.
12. After importing you will see that the schema is added and all configuration is preserved. 


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.infotopics.com/writebackextreme/troubleshooting-and-faq/faq/how-to-copy-a-schema-to-another-database.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.