Backup the Data Warehouse by Copying It to a Parallel Instance

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):

BEGIN
    DECLARE string sourceTable;
    DECLARE string targetTable;

    LOOP ON (SELECT "Name" as TableName, NameInSource as DVName FROM "SYS.Tables" WHERE SchemaName='sourceDWH' ORDER BY "Name") as cur
    BEGIN
        sourceTable = 'sourceDWH.'||cur.TableName;
        targetTable = cur.DVName;

        EXECUTE IMMEDIATE 'SELECT a.* INTO '||targetTable||' FROM (SELECT * FROM '||sourceTable||') as a';
        EXEC SYSADMIN.LogMsg(level => 'INFO', context => 'org.datavirtuality', msg => 'BACKUP-backup performed of '||sourceTable);
    END
END