Database Synchronization | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Database Synchronization

I am developing an application in Vb6.0 & backend as MS-Sqlserver 2k. this application is client-server & also i am developing for this my database will be offline & same database will be on webserver. now i want to synchronize those two databases which r offline & which is on web, means whichever update,delete,insert operation will take place at offline or db on web should affect both db.if i delete or update any record at offline db, when i will run db synchronization code then same updation should affect the db which is online.
i got db synchronization s/w but it just synchronize the structure of db but not the records.Please anyone tell me how to do that.
Have you read about replication in BOL.
I guess replication can solve your problem in this regard.
But read it before going for it.
thank you ranjit for helping me. but i don’t know about replication in BOL.can you give me brief idea of it please. where i will get info. about that.
Hi,<br />Please Refer BOL or go through the article below :<br /><br /<a target="_blank" href=></a><br /><br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
OPEN SQL Server QA and click on HELp.
Which will load Books ONLINE and there read about Replication.
Also you need to install replication components before implementing.
Also Madhivanan Failing to plan is Planning to fail
If not you can take help of log shipping too to restore the transaction logs on a timely basis and keep the secondary database on loading state. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
thnaks to all of you, i ve tried snapshot replication method, but it is not solving my problem. i ve tried it on local server. Mr. Satya SKJ , sir can you explain me in brief what u said, i am not getting your point.