Duplicate records inserted in SQL DB table with SqlBulkCopy javelin utility
search cancel

Duplicate records inserted in SQL DB table with SqlBulkCopy javelin utility

book

Article ID: 135202

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We are trying load data from Oracle source to Oracle destination using SqlBulkCopy import utility in javelin.
This is disabling unique indexes on target database and inserting duplicate records into target if the records already exists.
Because if these duplicate records in target table, unique index is being set to unusable state. 
Is there any option we could prevent “Disabling Unique indexes and constraints” in javelin?

We have found that, by specifying EVALUATE CHECK_CONSTRAINTS clause, CHECK constraints are not automatically disabled.
How can we specify this I javelin?  

Environment

Test Data Manager
TDM
Javelin

Resolution

It is not possible to change bulk copy settings. 
This is by design.