I need to achieve zero downtime for my e-commerce site when making database schema changes. The database is sql server 2005. Can someone check if the following steps are possible? Please provide your suggestions.
- The main database will serve the requests, and the changes will be replicated to the mirror database.
- Before deploying, stop the replication process from principal to mirror.
- Display database schema changes in the mirror.
- For a short pause, make basic read-only access.
- Re-copy the changes from the main to the mirror.
- Send mirror requests (perform role switching)
- Make database schema changes for the original principal (now the mirror after the role switch).
source
share