Table Copying

Fast & reliable test data provision
Corporations maintain large amounts of data in Oracle, Microsoft SQL Server and Db2 databases, and it is normal to find several separate databases for production, test and development. Refreshing test beds from production systems is a vital part of the development, testing and quality assurance life cycle. Obtaining relevant test data requires copying from one database system to another. The window of opportunity for copying or migrating relational data is constantly decreasing as the demands from 24 x 7 operations are increasing. Limited resources and shrinking batch windows make data delivery to QA difficult.

Refreshing test data may mean to simply overwrite everything in the target, but there are also situations were your target tables already contain data that you don‘t want to lose. In addition, in some cases the target schema has evolved and the structures have become slightly different. Copy tools must take this into account and be flexible enough to merge the data in a way that makes sense for test and QA purposes.

How XDM-TC can help
XDM Table Copying (XDM-TC) has this flexibility. It can replace, update or merge data into your target tables and it contains many built-in checks to make sure that the copy process is fully automated, reliable, fast, and can be restarted if necessary.

Because naming conventions in test and QA systems are often different from those in production, XDM-TC provides a powerful mechanism to rename your tables, indexes, and other objects. Renaming is rule-based and works by

deriving target names from source names. This allows XDM-TC to automatically detect, include and rename new objects in your source environment without the need to change anything in the process.

XDM-TC quickly and efficiently copies, updates and replicates, tables, and indexes. It can copy within a database, between two databases in the same instance, and also between different instances. A copy task covers both the physical data movement and the processing of the data structure (DDL). It can include any number of tables and will automatically create the objects in the target environment if they do not already exist. XDM-TC automatically selects the optimal way to move the data between the selected source and target database types.

XDM-TC works in multi-threaded mode and copies objects in parallel in order to maximize throughput.


All required scripts and commands to perform a copy are generated. This automation frees DBA staff from tedious, error prone manual tasks that are usually part of a large copy operation. The interface of XDM is easy to use and does not require users to have DBA level expertise about the different database systems.

To set up a copy process, all you need to do is specify the source and target system, and rules for the selection and renaming of tables. You can also choose if you want to replace target data, or merge the source data into the target. XDM then generates everything that is needed to do the copy.

The process itself is divided into several steps which can be run individually or combined. Once set in motion, no additional manual work is required, no matter if you run the process only one time, or if you intend to run it repeatedly using a scheduler. The process is flexible enough to react to changes in the source or target schema based on the options that you have specified. For example, XDM can drop and recreate target objects if needed.

All these factors contribute to the significant savings in run time, costs, and manual staff effort.

XDM TC supports the following platforms and database systems:

  • Db2 for z/OS, Db2 for LUW
  • Oracle for Windows, Unix and AIX
  • Microsoft SQL Server