Please read the entire project and submit ideas with your bid. Standard "I can do this" Will be deleted
We have a SQL 2016 Standard AG two servers (Server 2016 standard, SQL 2016 standard) at different data centers. The AG works as it should. The program that needs to read and write to the SQL AG in not AG aware. What I am looking for is a simple lightweight proxy agent that will run on each work station (oldest windows 7 32 and 64 bit, newest windows 10 64bit) so that the local program on the workstation will point to [login to view URL] (localhost) and the proxy would talk to whatever SQL was primary in AG. Secondary in AG is not readable.
Thanks for looking at my project.