Log shipping works well for single master scenarios and these solutions can be combined with a partitioned primary key space for inserting new rows in the remot

Log shipping works well for single master scenarios and these solutions can be combined with a partitioned primary key space for inserting new rows in the remote databases. A two-way embedded/server relational sync is a much more difficult problem but it has been solved before. SQL Anywhere is a commercial relational database that has exceptional synchronization capabilities for fleets of mobile devices. Its MobiLink gateway synchronizes with heterogeneous DBMS servers like Oracle. A new relational sync project should become familiar with MobiLink, in my opinion.