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

Applying changes from one server to other instead of Synchin

Hello

I had been using Redgate SQl Compare to compare the structure between two servers.
After comparing I do not want to synchronize them but apply changes from one server onto other
without changing anything on the other server(no drop or delete).
Please let me know how can i do that.
samrana
0

Comments

1 comment

Sort by
  • Anu D
    Hi,

    Thanks for your post!

    Yes you can move only the things that are different and leave alone/ignore the objects that do not exists in the Source and not drop them.

    When objects are grouped by Type of difference, the Type column indicates the difference:
    • objects that exist in both data sources but are different
    • objects that exist only in the Source
    • objects that exist only in the Target
    • objects that exist in both data sources and are identical

    If you are suing the UI make sure you select the Object that exist in both data sources but are different and objects that exist only in the Source.

    And if you are suing SQL Compare command line make sure you use the appropriate command: http://documentation.red-gate.com/displ ... e-/exclude:

    So command will look like 
    /exclude:Missing

    Let me know if this helps.
    Anu D
    0

Add comment

Please sign in to leave a comment.