best solutions : sql server replication (Maintenance)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

we are frequently running the maintenance tasks on production during that
databases are not accessible.
to avoid this we want to switch over to the standby server during maintenace
and after maintenance has been completed
switch back to primary server.During maintenance all data changes need to be
replicated back to production server.

To accomplish this I am planning to setup database replication from
producation database server to Standby server.
Please advise best solutions for this like microsoft trnsaction
replication,Goldengate replication, wansync replication.

I think microsoft trnsaction replication,Goldengate replication doesn't
support complex shema changes to get replicated.

Requirement :
1. 10 databases need to get replicated (with 30GB - 70GB each)
2. these 10 databases will have schema changes monthly.
3. data changes need to moved from standby to production server after
maintenance has been completed.

Please advise
Thanks


.

Relevant Pages

  • Re: custom data warehouse in python vs. out-of-the-box ETL tool
    ... Bill Inmon's "Building the Data Warehouse" is 17 ... My experience is that if you enjoy hacking around databases and are ... I had a server for each production DB, ...
    (comp.lang.python)
  • Re: custom data warehouse in python vs. out-of-the-box ETL tool
    ... I have an integrated system Dashboard project that I was going to ... My experience is that if you enjoy hacking around databases and are proficient in Python, than for small scale solutions it is preferable to do it yourself. ... I had a server for each production DB, a server that mirrored that production DB with some added columns per table for external synchronization purposes and a master synchronisation server. ...
    (comp.lang.python)
  • Re: Production & Test Environments
    ... The databases contain your contents, ... However on your web front end server if you have done any ... your dev server envoironment you will need to have all these files copied ... to become Production) all the documents etc... ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Application error
    ... Monthly wise i have scheduled for all databases. ... Do you have any maintenance in place on the database? ... we are getting this error in previous server also for so many ... Yesterday end users got a error while uploading batches into SQL ...
    (microsoft.public.sqlserver.server)
  • Re: Disaster recovery without backup but just files .edb & .stm
    ... i've to activate my exchange virtual server ... "ExchangeBackup" (exactly same of production), ... Your production server and DR server are both named "ExchangeBackup"? ... Mounting the databases on a server with the same name shouldn't cause ...
    (microsoft.public.exchange.admin)