Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
replication or cdc or timestamp or..?

已答复 replication or cdc or timestamp or..?

  • Friday, April 13, 2012 3:53 PM
     
     
    Sign In to Vote
    0

    Hi,

    I have tables in diffrente server and i need to have newest data in my server(database structure in same for all server)

    what is best way for this?I give all data for first time and

    1-I use cdc for tables on another server and i receive change data and with this changind, i syncronise my database with other server...

    2-I use replication

    3-I use timestamp for tables on another database  that i know changing data...

    4-....?

    Please help me,what benefits or defects for any way?

    thanks  

     

All Replies

  • Monday, April 16, 2012 2:33 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi sara19_s,

    According to your description, you may consider Peer-to-Peer replication to synchronize data between multiple servers to keep the relatively in real time data on each node. It might be a big deal to collect changes from multiple servers and apply them manually by taking use of CDC or timestamp. Please pay attention to this article about Peer-to-Peer Replication in SQL Server 2008.

    Stephanie Lv

    TechNet Community Support