Re: Database centralization architecture

It looks like you will need to use merge replication for this. With
hierarchies/republishing it should be able to handle what you are
trying to do. Note that it will add a guid column to each table you
are replicating.

Is there anyway you could migrate all user databases from each branch
office at one time? This should minimize the impact of such a move.


On Jan 31, 12:31 pm, "hemylio via SQLMonster.com" <u41023@uwe> wrote:
Hello everybody,

    I get the following scenario in my hands: I have a datacenter placed at
the company headquarter and around 200 branch offices spreaded across
Brazil´s states. Each one of them has one SQL Server that holds the databases
of 9 important applications. We now received a strategic decision to
centralize all applications and databases, thus we need to bring all
databases to datacenter. The development team adopted the strategy to migrate
on a per-application basis. The big problem with this approach is due to the
fact that these databases are highly dependent from each other. This model
will lead us to a situation where every time we migrate the application X in
one office, we would need to replicate almost the entire database X back to
the SQL Server at office so the other applications not yet migrated can
continue to work well.
     Thinking ahead, this number of replications will increase considerably
until the point where the management of this structure is seriously
compromised. I am trying to convince them to adopt the strategy to migrate on
a per-office basis, i.e., all databases would be moved together to the
datacenter. This would eliminate the need for replications down to or up from
the offices.
     My question is: has anyone here already been through a situation like
this? I still need more arguments to support my suggestion and any experience
from you would be valuable to me. Does anyone here recommend another strategy
besides those I presented above? Thank you.

Fabio Hemylio

--
Message posted viahttp://www.sqlmonster.com

.

Relevant Pages

  • Encrypting MS SQL databases
    ... I'm currently working on a solution needing to perform replications ... several laptops connecting to it. ... So I will need to encrypt the data in their databases, and AFAIK, MS SQL ...
    (Security-Basics)
  • Database centralization architecture
    ... I get the following scenario in my hands: I have a datacenter placed at ... Each one of them has one SQL Server that holds the databases ... centralize all applications and databases, thus we need to bring all ... this number of replications will increase considerably ...
    (microsoft.public.sqlserver.replication)
Quantcast