Hi,
I am here to ask about a way to handle data between two databse servers.
I have my one application running in my city office and another in country office. My City office has got regular[ un-interrupted ] internet connection but my country office do not have. It gets connected to internet in evening time once a day only.
I have developed a application for city office which can perform data analysis task as per the client. The same application is also installed in the country office. Both offices uses own application and database. Now I want my city office to get the data of country office regularly and check it similarly from the software.
I have thought to do the task by mail. First compress the country office database file and mail it to the city office. City Office downloads it and fetches to the program and get the data updated. Seems working... :)
But the system failed after period of time when the country office database file size increased by large times. For few MBs it was fine but now a days its going more than > 50MB which is very sad.
So in this context what other method can be used or what maintenance can be done on country office database system to decrease the filesize
I do have my offline application running in local server which stores all data during offline transaction [when online server is not available] in local database.
Now I would like to know what can be the best way so that after getting my online server back my offline transactions get synchronized.
Can I get some detail idea how can i do that?