Databases

Reference to Servoy Cloud Environment System Health dashboard

Overview

The Databases Overview is not supported for Remote Environments

The database dashboard in the Servoy Cloud Control Center displays all available databases along with key information for each one.

Details

Each clickable card on the dashboard provides essential information to easily identify the database, including:

• Database name

• Database icon: representing the type of database (e.g., PostgreSQL, MSSQL, MySQL)

• Database version

• SQL version

• Database status

• Context menu

Download Backup file

To download the backup file of a database from the Cloud Control Center, follow these steps:

1. Navigate to the Database dashboard from Application > Environments > Environment Details > Database

2. Find the context menu on the database for which you want to download the backup file.

3. Click “Download backup file”

4. Check your email for the Servoy Cloud GPG decryption passphrase.

5. Refer to our documentation on how to use the passphrase and decrypt the backup file.

---

Request Remote Database Access

Note: This action is only available for Production Databases and can be accessed by users with Manage Account Permission

Users can now request remote database access for production environments via the Database Overview screen. This allows users to perform troubleshooting, data analysis, or other actions requiring direct database access.

Request Remote Access for Production Databases

To initiate a request, navigate to: Environment Details → Database View → Actions Button → Request Remote Access.

A dialog will appear, allowing users to specify the required access type (readonly, readwrite), provide a whitelisted IP address, and include any relevant notes.

Once the request is submitted, a support ticket is created automatically, and access will be granted based on the provided details.

Remote Access Request Dialog

---

Restore a Database from Another Environment

Overview

The Cloud Control Center allows you to restore a database from a different environment within the same application. This is useful for syncing lower environments (such as DEV or UAT) with data from higher ones (such as PREPROD or PROD). This operation is restricted to ensure it is performed only when appropriate and by authorized users.

---

How to Access the Restore Option

To download the backup file of a database and initiate a restore:

1. Navigate to Application > Environments > Environment Details > Database.

2. Locate the database you want to restore.

3. Open the context menu (⋮) on the target database row.

4. Click “Restore database from environment.”

Note: This menu item will be disabled if the following restrictions apply.

Restrictions

• Production databases cannot be restored.

• Only PostgreSQL databases are supported.

• Restore is limited to environments within the same application.

• You can only restore from higher to lower environments.

• You must have production-level permissions

Valid restore paths:

• DEV can restore from UAT, PREPROD, or PROD.

• UAT can restore from PREPROD or PROD.

• PREPROD can restore from PROD.

---

Restore Process

You will be presented with a wizard to begin the restore

1

Step 1: Select Source

Select the source environment and database you want to restore from.

2

Step 2: Confirm and Run

• The wizard will show a summary of your choices, including:

  • Source environment and database

  • Destination environment and database (your current environment)

• Click Confirm & Run to execute the restore.

---

Duration

The restore process typically takes between 5 and 10 minutes, depending on the size of the database.

---

Important Notes

• The restore process completely overwrites the destination database.

• Always review your selections carefully before confirming.

• This action can only be performed by users with production-level permissions.