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

"view object synchronization script" option missing

Any chance this option could come back? It's very handy when you just need to grab part of a change without doing the whole object or database.

Thanks,
Traci
tkdennis
0

Comments

2 comments

Sort by
  • Alice E
    Hi Traci,

    The "view object synchronization script" has moved to the right-click context menu: just right-click in the SQL differences pane and choose "Show Object Synchronization Script".

    In the next release of SQL Compare, you'll also be able to access this option if you right-click on an individual object in the comparison results pane. (Unfortunately this bit didn't make it into the Beta).

    The reason why we moved it was because we'd prefer people to use the Synchronization Wizard to generate the SQL for their objects: that way things like dependencies and sync order are taken into account and script errors are less likely to occur.

    Can I ask you for some examples of when you use this option? Do you use it to build your own sync scripts? Are there other times when it's useful?
    Alice E
    0
  • tkdennis
    Duh - Thanks! I was looking for the little icon!

    Sometimes I just need one object, copy the object sync script and use multi-script to blast the changes to multiple servers. It's faster than deselecting all objects, selecting the one, going through the wizard, etc.

    This time, I discovered an index was out-of-sync and I was just looking to grab the DROP/CREATE INDEX without having to go back to SSMS and click my way into the right CREATE SCRIPT.

    Occasionally I have the situation where there are multiple changes to a table (multiple columns and multiple indexes) and I just want to synchronize one part but not the whole thing. So I go into the object to see if it generated a simple ALTER TABLE statement I can pick out and run separately.

    Thanks,
    Traci
    tkdennis
    0

Add comment

Please sign in to leave a comment.