This content has been marked as final. Show 1 reply
yes this seems a valid senario.
you will have some issues migrating to the sqllite (perhaps some queries changes) , dont forget that sqllite has (if im not mistaken) a smaller subset of the sql commands than the 11g. but apart from that yes, you will have a mobile server with a centralized 11g db, the clients will have sqllite(if you use the new olite or olitedb if you use the older olite 10gr3) and they can synchronize regularly.
synch can happen on user click,on a timely fashion, or even when the server pushes a request for sync.
you will have to follow the structure of olite, create the publications, mobile app etc so have a look at the olite samples/documentation and also posts in this forum for help