1

Please anybody suggest me how to write a script which compares the jobs on the primary and the secondary server.

Thanks, Venk

1 Answer 1

1

Red-Gate SQL Compare will compare and script all (or at least most?) objects between two SQL Servers.

They also offer an API that lets you write .NET code to programatically compare and sync objects.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.