> For the complete documentation index, see [llms.txt](https://docs.devolutions.net/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.devolutions.net/rdm/getting-started/installation/database-upgrade.md).
# Database upgrade
The information below applies to installations with workspaces that are using a database as their data store.
Some Remote Desktop Manager releases must alter the database structure. These are performed automatically for you but it is a best practice to perform a backup of your workspace beforehand. Additionally, if you are in a team environment, you must be the sole user connected to the database during the upgrade.
{% hint style="danger" %}
Key points to consider:- The user performing the update must have administrative privileges on the underlying database. (SYSDBA or DB\_OWNER).
* Perform a database backup and ensure that you can quickly perform a restore if required.
* If your organization allows for a read/write offline cache, ensure that all of your users have merged their offline edits.
{% endhint %}
Follow these steps for a successful version update:
{% tabs %}
{% tab title="Windows" %}
1. Verify your installed version of the SQL Server database. Consult our [Microsoft SQL Server](https://docs.devolutions.net/rdm/workspaces/workspace-types/native-workspaces/microsoft-sql-server/) article to know which versions are supported.
2. Ensure you are the sole user of the database during the upgrade process. If your environment allows for offline use, have your team switch to the offline mode, or have them switch to another workspace.
3. Back up your database using the database tools.
4. Install the desired version of Remote Desktop Manager, using a [portable (USB)](https://docs.devolutions.net/rdm/installation/client/portable-usb/) deployment model may be desirable if you are doing this on your personal workstation.
5. Open Remote Desktop Manager while logged on as a user with administrative rights. You must also be SYSDBA or DB\_OWNER.
6. You may be prompted with an upgrade message when your workspace is accessed. If so, accept the upgrade.
7. If you were not prompted with an upgrade message, locate your workspace to upgrade in ***File – Workspaces*** and open its property window.
8. Switch to the ***Upgrade*** tab, then click on ***Update database***.
9. Wait for a confirmation dialog.
10. Close the dialog.
11. Ensure your Remote Desktop Manager application is currently using that workspace.
12. Press Ctrl+F5 to force a full refresh.
13. Validate the content and perform a check of the technologies that are critical in your environment.
14. Update the client software on all workstations.
{% endtab %}
{% tab title="macOS" %}
1. Verify your installed version of the SQL Server database. Consult our [Microsoft SQL Server](https://docs.devolutions.net/rdm/workspaces/workspace-types/native-workspaces/microsoft-sql-server/) article to know which versions are supported.
2. Ensure you are the sole user of the database during the upgrade process. If your environment allows for offline use, have your team switch to the offline mode, or have them switch to another workspace.
3. Back up your database using the database tools.
4. Open Remote Desktop Manager macOS while logged on as a user with administrative rights. You must also be SYSDBA or DB\_OWNER.
5. You may be prompted with an upgrade message when your workspace is accessed. If so, accept the upgrade.
6. If you were not prompted with an upgrade message, locate your workspace to upgrade in ***File – Workspaces*** and open its property window.
7. Switch to the ***Upgrade*** tab, then click on ***Update database***.
8. Wait for a confirmation dialog.
9. Close the dialog.
10. Ensure your Remote Desktop Manager macOS application is currently using that workspace.
11. Press Cmd+F5 to force a full refresh.
12. Validate the content and perform a check of the technologies that are critical in your environment.
13. Update the client software on all workstations.
{% endtab %}
{% endtabs %}
#### See also
* [Devolutions Academy – How to perform a database upgrade in an SQL workspace](https://academy.devolutions.net/student/activity/2592286-how-to-perform-a-database-upgrade-in-an-sql-data-source)
---
# 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.devolutions.net/rdm/getting-started/installation/database-upgrade.md?ask=&goal=
```
`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.