Home Forums SQL Server 2005 SS2K5 Replication Need to replicate multiple databases (publications) to one central subscriber RE: Need to replicate multiple databases (publications) to one central subscriber

  • Yes you can do this.

    When you configure - do not allow snapshot agent to initialize. Select subscriber already has schema & data - do this for both publishers and manually initialize data yourself.

    Why is second not replicating? Do you have an error message? Do the same primary keys exist on both servers?

    ChrisB

    Chris Becker bcsdata.net