Backup the Data Warehouse by Copying It to a Parallel Instance

  • 10 June 2024
  • 0 replies

Userlevel 5
  • Community Manager
  • 21 replies

If you are not able to properly backup your data warehouse (DWH) with the means provided by your DBMS, there is still a way to perform a backup. Just follow these steps: 

  1. Create a parallel instance of Data Virtuality Server (don't forget to configure the port offset!).
  2. Connect to the 'new' DWH as DWH (this is where your DWH will be stored to).
  3. Connect to the DWH you want to backup directly as a new data source on the parallel instance with schema name 'source DWH' and importer.tableTypes="TABLE".
  4. Execute the following Code on within datavirtuality Studio connected to the parallel instance (successful inserts will be logged):

0 replies

Be the first to reply!