Shulou(Shulou.com)06/01 Report--

SQL Server often manages different data by sub-database, such as one database per branch. SQL Server DBA therefore often needs to manage dozens of databases. It can be painful if a large number of libraries need to execute scripts, especially when there is more than one script.

Recently found a very convenient SQL Server batch execution tool: SQLBatch Runner, its home page is: www.amgodata.com

Add the list of libraries executed on the left, add the SQL script on the right, and click on the execution. You can receive the result set returned by the execution, export it to Excel in batches, and protect the script for transactions.

When not registered, you can only execute 5 libraries and 5 scripts, and the registration fee is about $99, which is not a big deal for the company.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.