Page 1 of 1

synchronize offline data with online data

Posted: Mon Dec 18, 2006 12:50 am
by valen53
Hi,

i have a system in local hosting. but currently i have a branch at other place. i need them to keyin customer detail.
Currently i don't want put my system online. so i just create a small application to let them online keyin. after that i download the data and copy to my offline system. after process, i need to upload data to the online system.

But this way is quite troublesome, except make system online, any solution can provide to me?

Thanks

Ps:/ english is not very well.

Posted: Mon Dec 18, 2006 5:32 am
by Mordred
What about just copying the data back to the online version? Export SQL data from your local system, import in the online system.
Of course, backup first, and be sure to understand the difference the autoincrement values make when importing. Try the process on a second local copy first maybe.