Skip to content
← SQL Change Automation

How can we improve SQL Change Automation?

SQL Change Automation

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Support for databases using replication

I should be able to use SQL Release to deploy to a replicated database.

20 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Report…  ·  Admin →
completed  ·  Kendra responded  · 

SQL Change Automation projects now allow:

  • Creating granular scripts for deployment
  • Customizing isolation levels

SQL Change Automation does not generate scripts to add and drop articles, but it does support having this code added into migration scripts.

There is certainly more which could be added feature-wise to support replicated database, but at this is an older request for basic deployment support, I am going to close this as completed.

I very much welcome new suggestions with current use cases related to SQL Change Automation.

Show previous admin responses (1)

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Chris Michael commented  ·   ·  Report

    We need the ability to create more granular scripts for deployment to our replicated environment (using merge replication).

    For example, the ability to create a script with just index changes in it. The ability to have separate scripts to create, alter and drop tables. If we could get it to generate the add article and drop article scripts for replicated tables that would be magic!

  • Ed Morris commented  ·   ·  Report

    The base support would be to push table changes that are made manually in the database - currently we receive the error 'You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.' as the SERIALIZABLE transaction level is used. The desired support would be a way to identify replicated tables and provide a feature that pushes schema changes to all databases that are subscribed.