In a production site, the current configuration I am using is three SQL Server 2012 servers, with some databases configured with AON High Availability. I understand that between the AON High Availability databases, data would be replicated, but I was wondering if this remains true for the table definition. By my understanding, I believe that table structures not to be handled manually. CMIIW.
Assuming that is correct, what is the best way for me to deploy changes in table structure with minimal downtime?
It seems I missed out a similar question but with different wording, but nevertheless it answers my question: Do schema changes "break" SQL Server 2012 AlwaysOn or are they handled transparently?
Even though it's a duplicate question, but I think I'll keep this just for those who is searching it with a different wordings.