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.
Mirror data from SQL Server to MySQL on a computer with dynamic IP
mysql;sql server
My idea is simply save your query result to SQLite db, then upload it to your hosting, also add method to check if the db has changes, if yes then on your android download it, this method is suitable for db with minimal changes.