I don't think modifying them is possible.

Yes two way traffic either way

Are the databases on the same SQL Server instance? No

Does the movement of data need to be instant, or is a lag acceptable? Ideally instant but when you say lag...

Hi Phil

Thanks for the response, I guess at the moment I am trying to ascertain if its even possible.

My understanding is that the tables in the SQL differ between the...