If you want to sync two databases by code, you're looking for trouble. 

First of all, you need to handle your own primary key generation, because when inserting records on different sites, primary keys can/will be the same. Unique primary key generation is not easy to accomplish. 

Furthermore, you need some conflict resolution. Updates or Deletes made on either side have to be reflected to the other site. Often, you cannot solve conflicts without user intervention.  

My advise: look at built-in (two-way) replication, native to the database. It will save you a lot of headache.

Ideas for synchronizing records programmatically
I think that "solo spot" has the same meaning, but I don't know the meaning either.
