Applying changes from one server to other instead of Synchin

samranasamrana Posts: 7
edited February 29, 2016 7:45AM in SQL Compare 11
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.

Comments

  • Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
Sign In or Register to comment.