What are my options for a high availability system that requires regular roll out of schema changes. I am looking for an HA solution that allows hot fixing of SQL objects rather than just a fail over.
Example hot fixes might include new tables or altered tables and possibly the SPs to update/insert from these tables. I need to be able to roll out these updates with minimal or zero down time. All suggestions welcome.