I have an application which does monthly update of data in Database and also does select queries or minor updates. Monthly updates last for 24 hrs and application is down during the time.
I am planning to use 2 schemas. The first one will be used for minor updates/selects. The other one will be used for monthly update in first month. Once it is done, the second one will be used for minor updates/selects. Thus no downtime will be there for application. Will this method work? Or is there another way? Thank you.
May 23, 2008 3:25 PM
May 23, 2008 5:42 PM