What are the main differences between transactional replication and log shipping?


  • Hello All,

    In our current environment now, we have a database that serves has an application and ad-hoc database. Our goal is to remove the ad-hoc piece and move it to our current SSRS environment. The question is which method would be the appropriate solution for this goal?

    I'm thinking a transactional replication solution would be the best option because it is real time and less effort to set up. Is Log shipping primary used for a failover solution?  If I'm correct, this solution will not work for our environment because we do not want to failover to the SSRS environment. Please advice.

    Wednesday, February 27, 2013 4:14 PM


All replies