Would not it be easier to change connection string on the client side?

With this approach any connection opened to the main DB would be completed against the main DB, no matter how long would it take. And at the same time newly opened connections would be using the "substitution" DB.