I'm looking for a best practice/option to refresh one table only from Prod to Staging environment.
- The table in Source is loading daily with new data.
- The table in destination should represent new data only when refreshed.
Some of the options I'm thinking:
- Replication (Transactional)
- TSQL Script - SQL Agent Job
My first preferences would be to go with option 3. Will this be a good option? If yes can someone guide me to a script.