We need tools to audit databases and also to be able quickly to compare databases or to copy objects from one server to another.
So far I heard about Lockwood and Red Gate , anybody has any experience with different tools ????
The nice thing with Lockwood is it will compare objects, compare data, and create the change scripts for both.
The only bad thing is you must have sa rights on the servers you're comparing. The tool creates a linked server connection between the master and target in order to compare them. When you disconnect the tool will remove the temp linked server connection.
Let me know what other problems you're having and I might be able to help you out. Their website also has a support forum with some good info.