I have two disconnected SQL Server 2008 R2 instances with the same databases, but with different data. I want to capture the transactions from one database and redo those transactions on the other disconnected database of the same name.
I can't use ApexSQL Log. Is there any way to do this internal to SQL Server? Are there any other 3rd-party vendor applications that might work?