One thing that I would like to see is the ability to set up a compare project (for use on the command line specifically) wherein I can configure the option, at the table level, say, to only add rows to the target...or only update rows...or only insert rows.
When using data compare interactively, for a given table I can see which rows are to be inserted, which are to be updated, which are to be deleted, and I can decide whether to only do inserts, updates, deletes, or some combination of those.
What I'd like is the ability to save this type of preference in my project so that I could run it in batch and, say, only add/update records to my target database and not delete anything.
The main reason for wanting this is that I want to be able to populate a historical database from my live transaction database, and the live database gets purged from time to time of old records. I don't want to propagate those deletes down to my historical database, only add new transaction to it.
If there's already a way to do this that I've overlooked, please point me in the right direction