Hello, I am very new to Replication. I have just started reading replication because I think it can solve my problem. I am developing an application for client which has online as well as offline version. Online version would have SQL2K and offline application would have MSDE as database. Offline application is a stand alone application and would connect over VPN. Whenever offline application connects via VPN, synchronization should happen between both the databases. Offline application contains only part of data. Comparatively my rules are preety simple. If the data is updated in offline application, then it cannot be updated in online application and vice-versa. On overall basis, replication seems to be the option. But I have coouple of question in order to come to decision. 1. There would be many instances of offline application and so it can happen that many offline application connects to server simulateneously for Synchronization of data. And each instance contains different data regarding on the user. (So might require replication which accepts parameter). Not sure if it is possible with Replication. 2. I am not sure what would be the performance (time required for) of replication? 3. Does the table gets locked while replication? Thanks for all your help. Regards, Nilay.