Applying changes from one server to other instead of Synchin
samrana
Posts: 7
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.
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
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:
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
Let me know if this helps.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com