automating data synch with deleting
Posted: Mon 09 May 2022 15:09
We are using data compare to copy new and updated records from a source db to a local db,
As the source deletes records beyond a certain age and we want the local copy to retain all records adding those not already in the local and updating those in the local with changed records from the source, but never deleting those deleted from the source.
This works great in the UI simply unchecking boxes but we seem to have no luck with various command line switches trying to achieve the same result.
Any help is appreciated.
As the source deletes records beyond a certain age and we want the local copy to retain all records adding those not already in the local and updating those in the local with changed records from the source, but never deleting those deleted from the source.
This works great in the UI simply unchecking boxes but we seem to have no luck with various command line switches trying to achieve the same result.
Any help is appreciated.