One-way sync to Archive database, for ADD/UPDATE only?
jerryhung
Posts: 138
I am in need of designing an one-way replication/sync
Background
Only wants to keep say 3 months of data in LiveDB
but 2 years of data in ArchiveDB
So I have to think of ways to sync from LiveDB -> ArchiveDB, for all
- NEW records
- UPDATED records (indicated by ModifyDate)
- but not DELETED records in LiveDB though (although our application never deletes data in LiveDB)
Is there a way to setup SDC8 project for this?
and later on use it in Command File
I haven't used SDC in a 1.5 years so I forget the whistles and bells it has
Most important part - the SDC8 cannot delete anything in ArchiveDB, but by definition a sync updates EVERYTHING...
Notes
- only concerned about DATA changes, not schema changes
Background
Only wants to keep say 3 months of data in LiveDB
but 2 years of data in ArchiveDB
So I have to think of ways to sync from LiveDB -> ArchiveDB, for all
- NEW records
- UPDATED records (indicated by ModifyDate)
- but not DELETED records in LiveDB though (although our application never deletes data in LiveDB)
Is there a way to setup SDC8 project for this?
and later on use it in Command File
I haven't used SDC in a 1.5 years so I forget the whistles and bells it has
Most important part - the SDC8 cannot delete anything in ArchiveDB, but by definition a sync updates EVERYTHING...
Notes
- only concerned about DATA changes, not schema changes
Jerry Hung
DBA, MCITP
DBA, MCITP
Comments
With the command-line version of SQL Data Compare, you can use Exclude:Missing so that DELETE queries will not be scripted.