Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replicate many databases to central server Expand / Collapse
Author
Message
Posted Thursday, August 2, 2012 7:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, August 19, 2012 7:11 PM
Points: 1, Visits: 14
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
Post #1339593
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse