ArcGIS 10.3 has a toolbox tool to convert the SQLite .geodatabase file to a FGDB. Once converted you can add the data to your SDE however you choose. It's a manual sync, but better than no sync at all.
Thanks for the tip, but I must still be missing something. Running that tool (runtime to fgdb) still results in delta tables, not the actual data. The result is identical to the output of Russell's script, so I still have the same question.
Strange - every time I've used it the tool produces a geodatabase, and it takes care of merging all the delta tables together.
Is it possible that your SQLite database was modified after you pulled it from the mobile device?
Well... I'm not doing exactly what is prescribed here. Our IT does not allow iTunes (but they do issue everyone iPads...). So, what I'm doing is pulling the sqlite off of the ArcGIS Server. I was hoping, since the iPad reported a successful sync, that I might find data there. But I didn't, just the tables I referenced above.
Yeah - that's your problem.
You need to tell your IT department to get over their hang up with iTunes. Pulling the geodatabase off the iPad with iTunes is the ONLY way to recover the data so you can convert it and sync.
Before we started using iOS runtime apps iTunes was a no-go with our IT folks as well... But eventually even they have to wake up to progress.
- Mike