Activity overview
Latest activity by mkraley
No linked servers
SQL Compare 7.1.0.197 / comments
No linked servers
SQL Compare 7.1.0.197
Deadlock when synchronizing
When we are synchonizing two databases with a lot of changes, we will often see a deadlock error:
Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chos...
Thanks for the reply - I was a little worried about that. I can certainly create a script and update it manually, but I was looking forward to having this be part of the same process.
I hope you'll consider something in this area as a suggestion for future releases/products. I certainly think of SQL Agent tasks as just another part of the database schema. You gotta have it to make your solution work, and the tasks get updated just like any other part of the application, so they need to be compared, source controlled, and synchronized. / comments
Thanks for the reply - I was a little worried about that. I can certainly create a script and update it manually, but I was looking forward to having this be part of the same process.
I hope you'll...
SQL Agent jobs
Can SQL Compare (or some other tool in the RedGate arsenal) handle the scripts for SQL Agent scheduled jobs? I'd like to be able to update other copies of the database with the details of the SQL A...