Any DBA or developer that has ever faced the problem of moving data changes across databases.
One of most common problems a DBA or database developer may face is finding and syncing data changes efficiently between multiple systems.
In this session we will look into different methods focusing on effective use of T-SQL and explore how these methods can mixed and matched in your ETL workflows:
- Brute Force
- Log shipping/Read Only standby
- Rowversion datatype
- Change Tracking
- Change Data Capture
- Temporal Tables
Why I Want to Present This Session:
Free up time and energy by knowing all the options available, brute force is not the only path forward.