Two-Way Replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Two-Way Replication

Problem Currently: Web Servers and Internal Users point to the same database. Web site needs to run as fast as humanly possible, read/write access to the database. Internal users import data that will need to make its way over to the database the website uses. Could it be setup that changes to the website db get replicated over to the other database every 5 minutes or 15 minutes, and changes on the internal database get replicated over to the web database every x hours? Would this be possible SQL 2000 or SQL 2005.
I think you can do this from transactional replication of SQL Server 2000 —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com
Hi,
if the data of the internal database and webservers are need to get replicated in each other then Merge Replication would be usefull. Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
————————
http://hemantgirisgoswami.blogspot.com
can merger replicated subscribe act as a another publisher to another db?
—————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com
Hi,
i wrote this because i read an article by Alexander Chigrik on
http://www.mssqlcity.com/Articles/Replic/SetupMR/SetupMR.htm , here it shows a method of PUBLISHING SUBSCRIBER. Plz i am not offending you but its my humble try give a link for the same. Hope you won’t mind. Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
————————
http://hemantgirisgoswami.blogspot.com
]]>