Nothing has been set up. Im looking for ideas to see if this is possible. Replication the entire database with to ensure the two are in sync I don't think is a great solution. To m any tables etc.

Let me know what other information you think you need.