I am looking for a sql ha dr solution that allows users to write to multiple replicas. Is this possible in sql server?
For example: AG allows read from multiple replicas. But write only to primary replica.
I couldn't find a way to implement an architecture so that the application using sql server replica can read and write from both servers (like active active writes).