Results 1 to 7 of 7

Thread: Syncing data

  1. #1
    Join Date
    May 2002
    Location
    Cape Town , South Africa
    Posts
    30

    Unanswered: Syncing data

    Hi ,

    Does anyone how to sync data from one table to the exact same table on another server?PLease help

    TY
    Burner

  2. #2
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106
    See Replication in BOL.

  3. #3
    Join Date
    May 2002
    Location
    Cape Town , South Africa
    Posts
    30

    Syncing data

    Thanx , I know about replication and setting it up ..which i did ..what i want to know is there a paticular script one can use in the event that i dont want to use replication

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    With both replication and DTS available, I haven't even thought about this kind of thing since the days of MS-SQL 6.5! There's no reason why you can't do it, but it is a waste of energy... Both replication and DTS are drop dead reliable, and simple to use.

    -PatP

  5. #5
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    You could setup linked server, custom triggers and stored procedures for synchronizing tables.

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by Pat Phelan
    Both replication and DTS are drop dead reliable, and simple to use.
    -PatP
    Ya think?

    I've seems some quirky things with DTS...but that was 7.0
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Yeah, I'd have to take issue with any statement saying that Replication or DTS are drop-dead reliable and simple to use. They are each a melange of technologies that rely on many different services to operate correctly. If any quirk occurs in those services then they go down like rocks and they are hard to debug. I don't like them because they have so many points of failure.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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