Skip to main content
Skip table of contents

Copy Over

You are looking at an older version of the documentation. The latest version is found here.

The CopyOver method retrieves the current data from a given source and puts it into the local table. If a table with the same name already exists, it will be handled according to the selected cleanup method.

ParameterTypeDescription

dwh_table

string

Analytical storage table the data will be put into

source_table

string

Source object the data will come from

cleanup_method

string

Specifies the cleanup method. Valid values:

  • DROP (table will be dropped and recreated); default
  • DELETE (table will be emptied via deletion of all rows)
  • PIPES_PREFER_DROP not set and cleanup_method not set => DROP
  • PIPES_PREFER_DROP set and cleanup_method not set => PIPES_PREFER_DROP
  • PIPES_PREFER_DROP not set and cleanup_method set => cleanup_method
  • PIPES_PREFER_DROP set and cleanup_method set => cleanup_method

CopyOver Jobs

In addition to the CopyOver() method, the Data Virtuality Server also allows using the CopyOver technique on data sources via two procedures: 

  • createCopyOverSourceTableJob()

  • createCopyOverSQLJob()

For changing existing CopyOver jobs, two more procedures are available:

  • changeCopyOverSourceTableJob()

  • changeCopyOverSQLJob()

How It Works

To add a replication job in the Web UI, do the following:

  1. Open the replication job dialogue in the Web UI and go to the optimization menu.

  2. Click Create New Job and then Create Replication Job:

  3. In the dialogue, select the CopyOver tab:


See Also

Replication Jobs for more information on this type of jobs

Replication Jobs Procedures for detailed information on the related system procedures

A short guide on data replication types and use cases. CopyOver Replication for a post in the Data Virtuality blog on CopyOver replication


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.