Results 1 to 4 of 4
  1. #1

    Data Synconization

    Hi,

    I have two DB servers (MSQ SQL Server 2008) both are different locations, i need to synconize both databases data synchronization on real time means a bit change at 1st db server it will update at 2nd db server if a bit change at 2nd db server it will update at 1st db server.

    Is there any simple and effective way by which i can do this please guide i have no idea about it, i would be very great full if someone send me link with snap shoots.


    Thanks

    Tahir Atique

  2. #2
    Join Date
    Mar 2011
    Location
    Oslo, Norway
    Posts
    81
    Which edition of MSSQL are you running?
    Web and above should provide Replication service and Load Ballancing services, these services are designed to cluster multiple servers together, even across the internet.

    Replication service works best when the 2 machines are in the same domain but does not require this

  3. #3
    we have SQL Server 2008 Enterprise edition at both machines, i will be very thankful if you send a link with snapshots.

  4. #4
    Join Date
    Mar 2011
    Location
    Oslo, Norway
    Posts
    81
    have a look at these links, they should be able to assist you with how to enable and set up Replication:
    http://msdn.microsoft.com/en-us/library/aa337389.aspx
    http://msdn.microsoft.com/en-us/library/ms151198.aspx

    Or a quick google for MSSQL 2008 Replication tutorial will bring up a lot of results too, tho the first link from MSDN should suffice

Similar Threads

  1. mySQL & data synconization
    By mtahir04july in forum Programming Discussion
    Replies: 4
    Last Post: 01-28-2011, 06:32 PM
  2. Replies: 0
    Last Post: 03-21-2010, 08:28 PM
  3. Replies: 0
    Last Post: 01-19-2010, 09:32 PM
  4. Replies: 3
    Last Post: 12-29-2005, 05:11 AM
  5. Replies: 5
    Last Post: 11-21-2005, 11:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •