Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Location
    LA, CA
    Posts
    2

    Unanswered: synchronizing over a WAN

    I have two servers with identical SQL srever 2K databases on them. I need to sync them over a WAN. Does anyone know where I can find some docs or info on how to do this? Thx

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    replication, log shipping, triggers?

    What are you trying to do...

    Look at these:

    http://www.sqlteam.com/store.asp
    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.

  3. #3
    Join Date
    Dec 2003
    Location
    LA, CA
    Posts
    2
    I am trying to allow both databases to be entry points with the client software, and sync up say, every 15 minutes or so.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    ahhhh...bi directional updates...

    I'd say triggers...can you create linked servers to each other?

    Lots of stuff to worry about though....

    What happens if I update a row...all nice and happy, and you overlay my change? Could happen in a single db though...

    What's the front end?

    Here's another scenario...if you grab the data and hold it in the front end...

    You go back to update it...(and let's say you have a last update datetime column)..the update datetime is greater than the time you got the data?

    So now the data is different than what you were display...

    OK, Also could happen in a single db....

    I guess locking would be an issue....

    How big is the database going to be?

    And why not use 1 db?

    Are the client desktops?

    MSDE?

    Access?

    mySQL?
    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.

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    ahhhh...bi directional updates...

    I'd say triggers...can you create linked servers to each other?

    Lots of stuff to worry about though....

    What happens if I update a row...all nice and happy, and you overlay my change? Could happen in a single db though...

    What's the front end?

    Here's another scenario...if you grab the data and hold it in the front end...

    You go back to update it...(and let's say you have a last update datetime column)..the update datetime is greater than the time you got the data?

    So now the data is different than what you were display...

    OK, Also could happen in a single db....

    I guess locking would be an issue....

    How big is the database going to be?

    And why not use 1 db?

    Are the client desktops?

    MSDE?

    Access?

    mySQL?
    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.

Posting Permissions

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