Loading Profile...
Append Not Overwrite Syntax
I want to ensure I do not overwrite an entire db. I only want to add records that do not already exist in the database. As a result, can someone please provide the dbcopy command syntax to append records without overwriting other records?
1
person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
Create a customer community for your own organization
Plans starting at $19/month
-
Inappropriate?Hello Tara,
You can use the dbCOPY mode 'Append', which appends only records that do not exist in the target database. To ensure that only new records are transfered, dbCOPY checks all available primary keys.
In case that you do not have any primary keys in your table you can define virtual primaries by clicking on the blue icon next to the target column in the Field Mapping window.
Best Regards
EMPLOYEE
