Document toolboxDocument toolbox

Move your database to a new db-server

 


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.

The file ConnectionData.xml contains your encrypted connection parameters to your DB (C:\PerformerSuite\AppData\ConnectionData).

Do not forget to adjust your current firewall rules to allow the connection to your new database instance.

Step-by-step guide

SQLite

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

SQL Server

  1. Back Up

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

    image2020-7-20_8-56-43.png

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.


© 2024 bluetelligence GmbH. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of bluetelligence GmbH. The information contained herein may be changed without prior notice. bluetelligence and Performer Suite and their respective logos are trademarks or registered trademarks of bluetelligence GmbH. SAP, ABAP, BAPI, SAP NetWeaver, SAP BI, SAP BW, SAC, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany or an SAP affiliate company. All other product and service names mentioned are the trademarks of their respective companies.
Impressum – Legal Notice: https://bluetelligence.de/en/imprint
Privacy policy: https://performersuite.de/en/privacy-policy
Atlassian privacy policy: https://www.atlassian.com/legal/privacy-policy