zero downtime during database scheme upgrade on SQL 2008
Posted
by eject
on Server Fault
See other posts from Server Fault
or by eject
Published on 2010-05-12T12:08:08Z
Indexed on
2010/05/12
12:14 UTC
Read the original article
Hit count: 258
I have web application on IIS7 with SQL server 2008 as RDBMS.
Need get 0 downtime during future upgrades of ASP.NET code and DB schema as well. I need to get right scenario for this.
I have 2 web servers and 2 sql servers and one http load balancer whcih allows to switch web backend server for web requests.
Main goal is to make 1st web server and DB server up and running, update code and db schema on 2nd server and then switch all the requests to 2nd server and then main problem - how to copy data from 1st database 2nd (which was changed during upgrade).
© Server Fault or respective owner