DBMS: Microsoft SQL Server 2014
My company will soon be looking for a new way to replicate some database over to a different server to use for reporting. I know there are many ways to do this, and other people will be looking at some of them.
My specific task is to research software-based database replication product that isn't Quest's ApexSQL Log but works at the same level. Meaning, it reads the transaction logs on the source and recreates the transactions to be loaded into the destination (replicated) database on another server.
Do any of you have any direct experience with a software-based product that can replicate multiple databases and handle both DDL and DDM changes and can work with custom (ie. non-DBO) schemas? Even if it's "Do not use Product ABC because XYZ." It would need to keep the databases in sync, although some lag is expected and OK. Currently, we have a 5-15 minute lag on the sync and that is acceptable.