How to Synchronise offline/online database

Question

I want to merge a software with a website. i want to the database of online data and offline data will automatically syncronise. Is it possible, if yes how??   for eg.   Offline Database structure Table1 slno    name    rollno 1          atul       33 2       shankar   65 Online database Structure Table1 slno    name    rollno 1          atul       33 2       shankar    65   please help me.

Laxmidhar Sahoo · Accepted Answer

make two connection for offline and online database   fill the ddataset from offline   in the loop collect each row of offline and in insert statement send it to    online database that used the online connection

Pradeep Shukla · Answer

Thanks for your reply.   But how to update online database from offline database?

Pradeep Shukla · Answer

both database have rows.

Laxmidhar Sahoo · Answer

whether one database is empty and another has rows or both database have rows ?