Summary

Your database needs to move to another database server or instance and you wonder if there is something to consider?
Nothing special needs to be considered. This should be a basic "backup and restore /dump and import"-process.

Your database-administrator should be familiar with this process.

As long as the database permissions are correct after the migration, you should be able to connect to your DB again without problems.

• SQL Server Setup (Recommended)

• Oracle Server Setup

Step-by-step guide

SQLite

Just copy and paste the .db-file to somewhere else to backup.

SQL Server

1. Back Up

   Open

   

2. Restore → "Device" on the new database-instance

   Open

   

Oracle

Export

1. Run "Data Pump Export Wizard"
   
   

2. Select "Schemas"
   
   

   
   
   
   

3. Select the User (Schema) you want to dump (backup) and press the blue single arrow.
   Proceed to step Output files.
   
   

4. Give the dump (backup) a name and disable the 2 checkboxes
   
   

5. Follow the wizard until the export is done.

Import

1. Activate DBA
   
   

2. Add connection
   
   

3. Run "Data Pump Import Wizard"
   
   

4. Select your dump name
   
   

5. Select your source Schema
   
   

6. Choose how your new schema (User) should be named
   
   

7. Follow the wizard.
   After the import is done you should see the imported schema. If not - do a restart of the application.