Syncing data across platforms

If I understand your question correctly, you want to "sync" the database from the android device to the desktop program.

You could write code for the Desktop program that looks at a copy of the database from the Android device and then walks the database and checks for certain fields. If they aren't in the desktop copy then grab the data and insert it.

I do this with a recipe database I wrote for my wife. I can back up the database on my device, copy it to hers, then a subroutine within the program checks for recipes that I've added to mine and copies the data.

Thanks gregwa but I was looking for a method of syncing without having to copy databases around.

My thoughts at the moment are that it outputs xml files to dropbox. These files will be named using date and time (yyyy-mm-dd-hh-ss.xml). Synced devices would then retrieve all records since the last sync date and time. Not sure how the files would be searched yet.

How large is the database? If it is not too large then it might be simpler to copy the full database. If you need to sync the databases then you can open the downloaded data and retrieve all the records that are more recent than the last successful sync.