Replicate many databases to central server

• Lenny Miranda Matos

  Grasshopper

  Points: 13

  More actions

  August 2, 2012 at 7:38 pm

  #98727

  Hello, I want to replicate many (almost 50) (published) databases to central (subscriber) server. Published databases are similar, not equal, but there isn´t in these databases any duplicated table name and subscriber server will be accesed from web.

  My preocupation is about the bandwidth in the server. What is better replicate 50 databases to 50 central databases or 50 databases to 1 central big database with all needed tables, views, procedures and functions from 50 published databases...?

  Thanks in advance ...

  Lenny