Post reply

Office backend db and Online db Synchronization

  • May 21, 2008 at 3:26 am

    #185816

    Dears,

    I have an application that runs inernally on the LAN. The backend db is SQL Server 2005. Some of the functions of that application are being publicly available to online user via a separate web application. The backend db is SQL Server 2005 as well and have exactly the same schema and every thing but is running on a different server. The two applications are not sharing the same db for performance and security reasons.

    Now, I want a real time synchronization between the two dbs so that when an online user performs a transaction the data in the online db gets synchronized ASAP with that in the backend database and vice versa. What is the best way to achive this and what are the performance and security implications?

    Thanks a lot for any help

  • May 21, 2008 at 6:07 am

    #818497

    Duplicate post. Please do not reply to this.

    http://www.sqlservercentral.com/Forums/Topic504304-291-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply