How can we help you today? How can we help you today?

Using SQL Compare to push schema changes to replicated table

Hello,

I was wondering if it is possible to push schema changes to tables that are transactionally replicated in SQL 2014 using SQL Compare? I have tried using the tools as I normally do but it seems to keep breaking replication. I found an article on MSDN that talks about using sp_repladdcolumn and sp_repldropcolumnrather than ALTER TABLE, but would like to be able to use a tool if possible.

Any thoughts would be appreciated.

Pete
pmourfield
0

Comments

2 comments

Sort by
  • Eddie D
    Thank you for your forum post and sorry for the delay in replying to you.

    SQL Compare does not fully support replicated databases and replicated objects. I have added the details of this forum post to an existing feature request, reference SC-2437. The feature request is requesting that SQL Compare handle replication correctly.

    I also recommend that you create a new User Voice forum TOPIC. The User Voice Forum is the preferred method of submitting a feature request. The more votes and comments a topic receives will increase the chances of a feature being incorporated into a new version of SQL Compare. The User Voice Forum is activley monitored by the Development Team and Product managers.

    Many Thanks
    Eddie
    Eddie D
    0
  • pmourfield
    Thanks for your response. I have added this request to the UserVoice site here: http://redgate.uservoice.com/forums/141 ... -databases

    Pete
    pmourfield
    0

Add comment

Please sign in to leave a comment.