Is Replication Only Solution For Us? -

• curious_sqldba

  SSC-Dedicated

  Points: 36502

  More actions

  December 31, 2011 at 12:00 pm

  #1427243

  mmartin1 (12/30/2011)

  ---

  Hi

  So from your latest post, I gather you have a synonym to a remote table? That is, it points to a table on another database in the same machine or another server? If I am not misunderstanding, I would create a local synonym for each one on the remote server. Then you just replicate the tables to keep things simple. Are your set of synonyms constantly changing?

  Both, we have synonyms pointing to local as well as remote. There is a reason why we have synonyms going to remote, all insert/update/deletes go to publisher and reads go to subscriber.

  I was wondering if there is any third party soln for this?