For production deployment that includes a Database script, We are shutting down the application and then executing the scripts. The business has raised a concern regarding this frequent application outage and they want the application to highly available.
Could you please clarify whether we can execute the db scripts when the application still up and running ?
Will it have any kind of impact for the application or for the users who are connected at that point of time ?
Understand for a new table DDL/DML it won't create an impact to application . But for existing table DDL/DML what kind of application impact can we except
What are the best practices for these deployments ?