mamlaide
asked on
Tool for SQL DBAs
I currently in a team where we manage about 50 SQL servers which have the same schemas and each time we need to make changes we have to go server by server to do that. Is there some kind of tool for DBAs that I need to be aware of. Especially this tool should be able to deploy scripts across the servers.
Thanks
Thanks
I think red-gate tools are doing it (http://www.red-gate.com/products/sql-development/sql-compare/)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Reg-Gate. They have a free 14-day trial for their tools for you to evaluate them. Also, they will grant you a free extension to you trial, if you need it. You can get the extension by sending an email, without dealing with a sales rep.
1. Powershell scripting
2. Registered servers