Constraints and indexes left behind while test data export
search cancel

Constraints and indexes left behind while test data export

book

Article ID: 231481

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

As part of data refresh activity while copying data (using Build Windows Export/Import queries) from oracle source environment (all the constraints present here) to oracle Target environment (only tables are present), its only copy data.

Questions:

Does Data Maker only copy Data from Source to Target or it also copy Constraints ?

Is it prerequisite to Build schema at the target environment before loading data ?

 

Environment

Release : 4.9.1

Component :

Resolution

As per design behavior, Subset will only copy the data from source table to target table. It will not copy the constraints and schema indexes.