SQL Server Performance

How to replicate selected tables from multiple sources to a single destination ?

Discussion in 'SQL Server 2005 Replication' started by kmathi, Nov 6, 2008.

  1. kmathi New Member

    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
  2. ndinakar Member

    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.

Share This Page