I am looking for a best practice / option to update a table only from the Prod to Staging environment.
- The Source table is loaded daily with new data.
- The table at the destination should represent new data only when it is updated.
Some of the options I'm thinking:
- Replication (transactional)
- TSQL Script – SQL Agent Work
My first preferences would be to go with option 3. Will this be a good option? If so, can anyone guide me to a script?