What are the challenges you face when working across database platforms? Take the survey

Optional delete statements / optional merge instead of inserts

Hello, I have the following scenario here:

Our tables have primary key values that are filled using sequences. Some of the tables we provide have master data in it, that is provided by us, but the customer should be able to enter new masterdata if needed.
So we have special logic in the sequences: On customer systems, they are counting from 100000 and up, on our reference database, they start from 1.

On each release date, I have two databases
a) a reference database with all the metadata neded (with keys starting from 1).
b) an empty database with same structure

Using "RedGate Data Compare" I can create a script for insertion of all relevant data.

The problem when deploying this to our customer database is, that most of the records are already exisiting in the customers database, so i get errors.

The best solution would be one of these:
a) an option that would generate a delete command for each insert
b) an option that would generate a merge instead of the insert

Is this possible / something that may be implemented in the future?



Sign In or Register to comment.