SQL Server 2008 Replication RRS feed

  • Question

  • SQL Gurus

    In our environment we have sql 2008 database running with 80 compatability mode. We want to replication selected tables in a DB with selected no.of rows. I figured that snapshot replication suites best for our requirement as we are replicating data to subscriber twice a day. But the actual problem is the subscriber DB is hosted on SQL 2005. I am not sure if the replication will be sucessfull from a publisdher in 2008 with 80 compatability mode. Well the easiest answer would be try it out and then confirm if it works! But, if you guys can let me know out of your experience that would be great!

    Early replies are highly appreciated.



    Friday, March 19, 2010 2:51 AM


  • Ali,

    SQL Server replication will support between 2008 and 2005.

    Rajesh Kasturi Please click the Mark as Answer button if my post solves your problem.
    • Marked as answer by Ali0321 Monday, March 22, 2010 8:05 PM
    Friday, March 19, 2010 6:45 AM