snippetMinor
How to do a bulk load of a database when application are relying on it?
Viewed 0 times
howapplicationarebulkdatabaseloadrelyingwhen
Problem
In a daily routine, I need to drop and do a bulk load of a database.
The problem is that I have a WebApp relying on that database. So I can't drop the database just like this.
What would be a good way to tackle this problem ?
The problem is that I have a WebApp relying on that database. So I can't drop the database just like this.
What would be a good way to tackle this problem ?
Solution
Do you need to drop and reload the database? In a case like yours, I would look at a way to synchronize the database with the reference set (the data you are loading).
An alternative approach would be to have two databases. Load a different one each day. Configure the webapp so that you can swap databases on the fly.
An alternative approach would be to have two databases. Load a different one each day. Configure the webapp so that you can swap databases on the fly.
Context
StackExchange Database Administrators Q#3653, answer score: 6
Revisions (0)
No revisions yet.