Configure Auto Database Replication Problem Using Sql Server 2000
-
Dear All, Iam new to MS SQL Server 2000 Administration. I have a small problem. I want to Configure Auto Database Replication. I have 2 databases 1) Database 1 2) Database 2 The data should be copied from Database 1 to Database 2 when ever a insert, delete, update happened in the Database 1.Any changes in the Database 2 Should not affect to Database 1. Overall if any thing chages in the Database 1 ,Same changes should happen in Database 2. Please help me on this. Thanks & Regards Veeresh
i want to join this group
-
Dear All, Iam new to MS SQL Server 2000 Administration. I have a small problem. I want to Configure Auto Database Replication. I have 2 databases 1) Database 1 2) Database 2 The data should be copied from Database 1 to Database 2 when ever a insert, delete, update happened in the Database 1.Any changes in the Database 2 Should not affect to Database 1. Overall if any thing chages in the Database 1 ,Same changes should happen in Database 2. Please help me on this. Thanks & Regards Veeresh
i want to join this group
You'll get a good starting point from this article: How Transactional Replication Works[^]
The need to optimize rises from a bad design. My articles[^]