Database Synchronization | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Database Synchronization

Hi,
I am developing an application in Vb6.0 & backend as MS-Sqlserver 2k. this application is client-server & also i am developing for web.in 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.
hi,
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=http://www.mssqlcity.com/Articles/Replic/Replic.htm>http://www.mssqlcity.com/Articles/Replic/Replic.htm</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
http://vyaskn.tripod.com/repl_ques.htm 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
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
hello,
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.

]]>