Hi there, My task is to setup realtime replication (SQL 2005) from multiple source databases from multiple geographic locations for selected tables to a single destination database. That is., table A, B, C from source I, table D, E, F from source II, etc all to one destination database This is the first time I am trying to do the replication setup for first time in SQLServer. Can I get some guidance from where to start and where to go for good documentation/step-by-step details ? Thanks & regards
Books on line has very good instructions on setting up Replication. Configure your Distributor first, then configure/setup publishers from both servers to use this distributor. Add the Subscriber to both publications.