# Exporting a store database from Central Administrator

You can export an existing store's database and use it as a template when creating a new centrally-managed store.

{% hint style="info" %}
Create a store in Central Manager before starting this procedure.
{% endhint %}

1. Open **Central Administrator**.
2. Connect to the **Central database**.
3. Click **Export Store Database**.

<div align="left"><img src="/files/KAqBMnufHMFkYOvdKrTv" alt=""></div>

4. Click **Next**.

<div align="left"><img src="/files/qa8w0PhJuQflzMG7cAjm" alt=""></div>

5. Select the store. This is the new store that you created in Central Manager for which you want to create a new database.

<div align="left"><img src="/files/aockDv7hrDOGWCKoKV1B" alt=""></div>

6. Click **Next**.
7. Click **Connect**.

<div align="left"><img src="/files/rydQrA4e53vCpxXKscVv" alt=""></div>

8. Enter the connection information for the template database. The template database is the database of an existing store that you wan to use as a template for the new store.
   1. Select the **SQL Server** where the template database is hosted.
   2. Select the **Connection method** for the SQL Server.
   3. From the **Database** drop-down, select the template database.
   4. Click **Connect**.
9. Click **Next**.
10. Click **Create**.

<div align="left"><img src="/files/Th6PH6llCH0pbHzlTKRK" alt=""></div>

11. Connect to the SQL Server where you want to host the new store database.
    1. Select the **SQL Server** where you want to host the new store database.
    2. Select the **Connection method** for the SQL Server.
    3. Click **Connect**.
12. Click **Next**.

<div align="left"><img src="/files/APVaLEaAHGHaoS9U1lHm" alt=""></div>

13. Enter the **Database name** for the new store database.

<div align="left"><img src="/files/nIXw0EvNgSnOWxIzvTkt" alt=""></div>

14. For **Initial Size**, enter the initial size of the database, e.g., 20MB.

<div align="left"><img src="/files/62a2yb0vSEp3HDAXXlx3" alt=""></div>

15. (Optional) Select **Automatically grow database size** if you want the store database size to automatically increase in size as it grows.

    <div align="left"><img src="/files/tL7XeTb5Rm5WVzgEnl4E" alt=""></div>

    1. Select how you want increase the database size: in megabytes or by percentage.
    2. Select how large the database can get. You can choose unrestricted growth or restricted growth . If you select restricted growth, enter the maximum database size in MB.
16. Click **Next**.
17. Click **Finish**.

<div align="left"><img src="/files/rlJiCbqRy9Jvf04LXhPu" alt=""></div>

The new store database is created on the SQL Server. You will see updates as the tables are created in the database. This new store database is empty.

<div align="left"><img src="/files/IfKSfBs2OAlCRxb0LaNM" alt=""></div>

18. Click **Next**.

<div align="left"><img src="/files/eS9lUEviWED4FDfAYg2K" alt=""></div>

The data from the template store database is exported to the new store database.

<div align="left"><img src="/files/6iU6KYIhKDD0zds0Ipob" alt=""></div>

19. Click **Next**.
20. (Optional) Click **Backup**.

<div align="left"><img src="/files/fuc8yHagt0RQcncOWY4O" alt=""></div>

{% hint style="info" %}
If you are moving an existing store database to a new SQL Server, you can select **Delete store database after backup is successful** to delete the original store database.
{% endhint %}

21. Click **Next**.
22. Click **Finish**.

<div align="left"><img src="/files/Nknh2aWNodWmU4TMryGH" alt=""></div>

23. (Optional) The message **Do you want to export another store database?** displays. Select **Yes** to repeat the procedure and export another store database or click **No** to exit.

<div align="left"><img src="/files/as8vRWHLXTyL5XYpPsrS" alt=""></div>


---

# 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://docs.rmhpos.com/installation/other-procedures/central-admin-export-store-db.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.
