zero downtime during database scheme upgrade on SQL 2008
- by eject
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).