CREATE web api to connect database with SQL Server 2008 with web server running mySQL / PHP

Closed

NEED to create a database sync between two database platform one windows SQL 2008 and the other mySQL running under cPanel or linux.

If anyone is skilled enough or have done something like this in the pass please message me.

I have a local web server with the site running on it right now (windows server 2008) and it's running fine. It connects to my webserver also running windows. I have configured Logshipping to match the database so my website can read that large amount of data in our webserver.

I have two servers. Both running SQL 2008R2 and doing logshipping.

local server has a test site and SQL running on it. Both working and running fine.

SQL database send a copy of the database using logshipping to the live web server.

SQL Logshipping is running fine on the live server but sometimes the connection between the logshipping drops.

I wish to not use the windows webserver and switch it to a linux but, still need the data to sync up into my website.

what would be the best way to approach this? any suggestions?

Need the job fix as soon as possible.

Skills: Database Administration, PHP, SQL, Web Hosting

See more: web api sql server, api fix, the best job to have, my sql create database, create a web server in php, cpanel mysql database, sql server job, cpanel windows, web api, test sql server, sql server c# 2008, mysql and sql, create cpanel, API connection, windows web server php mysql, server server, live connect api php, sql database sync, php sync, mysql sync api, windows php web server, web server php, mysql running, cpanel api php, linux web server database

About the Employer:
( 9 reviews ) Hacienda Heights, United States

Project ID: #5316627

7 freelancers are bidding on average $220 for this job

AcuityInfotech

Hi,    We’ve had a good look at your project description and we’re very interested in providing a solution. would be a two way solution 1st script to be installed at the Windows server and 2nd script to install at More

$252 USD in 3 days
(23 Reviews)
6.6
acer2004sl

Hello, I think we need to think together about that. you want a BRIDGE between your local copy, and the live one, yes? So, simply please let me know which one will be the original, and which will be the rep More

$252 USD in 3 days
(154 Reviews)
5.9
winnet21

Hi, I am very interested your project i have a question 1. mysql and sqlserver support remote connect (ip , username, pw, port) ? please refer programs that I done here: http://winnet.vn Look forward to wor More

$222 USD in 15 days
(16 Reviews)
5.0
pnjadhav

I am available right now. I am a expert Database Architect. I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, More

$277 USD in 10 days
(4 Reviews)
4.1
STSPvtLtd

Hi, I am 6 years experienced developer and I have done same when converting ASP.NET site to PHP. Let hire me, I will do for you too. Thanks Jitendra

$250 USD in 7 days
(3 Reviews)
2.8
solutnprovider

A proposal has not yet been provided

$155 USD in 3 days
(3 Reviews)
0.8
michaelgugino

Hello, I am a Red Hat Certified System Administrator in the Washington DC area. I have over 7 years IT experience, with about 5 years working with MySQL. At my day job, I maintain our MSSQL server installation, More

$133 USD in 3 days
(0 Reviews)
0.0