Transactional Replication Question

Hello. I attended a presentation on SQL Clone at SQL Saturday Phoenix. One of the operations that was not supported by SQL Clone was Transactional Replication, which is used quite heavily in my environment.

Are there plans to include support for Transactional Replication at some point, or is it a feature that can't be supported due to the structure of the cloning setup?

Thank you for any information you can provide on the matter!

Comments

  • Hi 3kernodle,
    We can't see a reason transactional replication wouldn't work -the SQL Server engine sees a clone database as a normal database - but we haven't tested that yet.

    It might be a setup that needs careful management though; transactions posted into the SQL Clone database would be written to the differencing disk which is local to that SQL Server instance (in its default data directory).

    So leaving replication running on the same clone database could cause that file to inflate to the extent that much of the benefit of using a clone database is lost.

    It might work to have a clone database which is configured to be a replication subscriber, which is then refreshed daily (dropped and recreated from a new, more recent image).

    I expect you would need to be able to add and remove the subscription for that database programatically in order to make that manageable.

    Sorry for the delay in getting back to you, I was hoping to get a worked example in place - and possibly a blog post - before weighing in on it. I still hope to do so in the near future.
    hope this helps
    Richard
    (SQL Clone Product Manager)
  • Hello Richard,
    My client also wants to use SQL Data Compare to replace SQL Replication, the scripts that generate insert statements are perfect for this purpose, but the records that are 'different' appear to be problematic. If data is updated in both the production and subscription databases, how does the SQL Data Compare decide which data elements to update? In my experience, the 'differences' script will write a blank on top of a more recently update field with content. Am I missing something?
Sign In or Register to comment.