Post reply

Tool to execute large number of scripts on large number of databases

  • January 28, 2012 at 5:18 pm

    #263467

    I'm having a trouble finding a tool that fits all of these criteria

    - execute multiple scripts on 200 databases spread over 10 sql servers

    - pause on script failure and show error with option to proceed/stop/skip

    - log all script results to files

    - import a execution plan from a text editable file so we can generate plans quickly

    There are tools that will do the first, but the other three are either not handled, or expect you to look through text files manually for errors, etc.

    Does anyone have any suggestions?

  • January 29, 2012 at 12:09 am

    #1439713

    Check this tool.

    http://www.red-gate.com/products/dba/sql-multi-script/

  • January 29, 2012 at 4:17 pm

    #1439800

    I actually tested the trial version of that software, but it has no option to save or edit a project file.

    It is just as fast to manually run scripts as it is to rebuild a script execution list within this tool every time.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply