Applying changes from one server to other instead of Synchin

samrana

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.

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.