Microsoft SQL proxy agent

$30-250 USD

Completed

Posted

about 5 years ago

$30-250 USD

Paid on delivery

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.

Project ID: 18836001

About the project

6 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@dsengar121

Hi The simplest solution will be to configure a FQDN in the application for SQL servers. A windows service can be written which runs in system context and polls for the primary server in AG and then updates the hosts file on the local system with the IP of the primary server against the corresponding FQDN. This way you reduce complexity and cut down additional processing of queries being sent through the proxy agent. Please let me know if you want to proceed with this idea.

$111 USD in 20 days

5.0

(22 reviews)

4.4

6 freelancers are bidding on average $655 USD for this job

@superbpartner

Flag of LAO PEOPLE'S DEMOCRATIC REPUBLIC

Hi,dear. I am very interested in your project - 'Microsoft SQL proxy agent'. I've already done this kind of project before. I'm a professional programmer with 12 years of experience. If you award me, I'll implement all of your requirements in a short time. Skills: .NET, C# Programming, Microsoft SQL Server, SQL, Windows Server

$155 USD in 1 day

4.5

(9 reviews)

4.7

@peralaDileepRao

I my self trained and capable to work and give me a chance to prove my self and send regarding details and payment confirmation I have trained in all the technologies asp.net mvc, asp. net, c#, SQL, HTML, JavaScript, Ajax, jquery, angular js

$3,333 USD in 7 days

0.0

(0 reviews)

0.0

@Aksalw18

Professional experience in c#, sql server, .net etc. Worked on projects that have two servers one is primary and another secondary, create a system that able to do the tranactions on offline mode also if primary server is down.

$155 USD in 3 days