Here is my problem, I have a task to create an android app to display data from our SQL server, the problem is our SQL server is not online.
We have a MySQL server too, the MySQL server is online, so I came up with the idea to mirror data on SQL server to MySQL, because our SQL Sever is not online, I have to use another computer to connect to both server.
What is best practice to do this? Thanks.
EDIT: SQL Server computer is in our office, but I can't touch it, MySQL is in a web hosting, the computer that I want to use to bridge the two server is online but with dynamic IP.