How to Implement Distributed Databases Using SQL Server 2008

• azhar.iqbal499

  SSCrazy

  Points: 2812

  More actions

  December 14, 2011 at 2:53 am

  #247609

  Currently, We have central Database at HeadOffice and users from suboffices ,scattered around the county, connect to central database.

  Now we want to distribute the database in disconnected mode at each Suboffice level and we want data to be synchronized at the day end at the central Database from all others Databases. We also want ransfer of data to all Databases from central Database.

  Please refer me the tutorial or way to implement this scenario in SQL Server.

  Thannks in Advance.

  Azhar Iqbal.

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  December 14, 2011 at 3:07 am

  #1421138

  Replication: http://msdn.microsoft.com/en-us/library/ms152567.aspx

  OR

  Distributed Transactions: http://msdn.microsoft.com/en-us/library/ms177403.aspx