Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004

    Unanswered: Database Synchronization


    I'm currently working on a Database Synchronization project and I wondered if anyone had any ideas other than what I've got so far. The context of this project is that we have a central server which stores data for 10 different locations in a consolidated database. Each store contains a replica of that database, but with only data relevant to their own operation.

    Store owners can change data at the store level or chain owners can change data at the central level, but for either change the other level has to be notified. I currently have 2 ideas on how to do this.

    Note: I am using MS SQL Server 7 for the central, but MSDE (Desktop Edition) for the store levels. So, replication from the store to the server is not available. I think I need to actually code this on my own.

  2. #2
    Join Date
    Mar 2004

    Solution #1

    When we are writing data to the central or the store level we use ASP.NET and some SQLConnection class to query the database. I could write a descendant class of SQLConnection that when an insert, update or delete occurs, a log is kept of these transactions and another program will pick up these transactions and execute them on the appropriate machine for synchronization.

  3. #3
    Join Date
    Mar 2004

    Solution #2

    We could also parse the MS SQL Server log files at the end of each day and look for transactions that will affect the synchronized database, but I'm not sure how to parse this log files, or if it will be slow to do so as there may be a lot of transactions that are not updating any data.

  4. #4
    Join Date
    Nov 2002
    I would use triggers, add and update datetime column and schedule a batch window, the bcp the data out and ftp it to the "client" databases...

    The client the would just replay the action.

    I would even say, make an actual column that would contain the sql, so they replaying mechanism would be very simple


    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