Just an update: I have decided to go with Change Data Capture. And scheduling a SSIS package every X minutes to write the changes to the new DB. It won't be real-time, but near real-time. The triggers may just be too bad performance wise