Thanks for the feedback guys, really appreciate it!

I have looked into replication services, however our database has been around since the 90's and developed into a beast which it is...

Excellent, Ill look into replication services too... Thankyou 🙂

Thanks Dan,

The bottom line on what I am trying to achieve is as close to real time mirror of say table A in the source to Table A in...