View Issue Details

IDProjectCategoryView StatusLast Update
0000862Database Workbench v6Generalpublic2022-01-12 13:18
ReporterDoychin Bondzhev Assigned To 
PrioritynormalSeverityfeatureReproducibilityN/A
Status acknowledgedResolutionopen 
Product Version4.4.5 
Summary0000862: Execute single SQL Script to multiple database connections
DescriptionThere are situations where we have multiple instances of same database schema and when we need to make changes to that schema we need to connect to each instance and run the SQL script.

It will be great if we can write our Script in a dialog and then select the connections against which the script will be run. Then hit the Run button and after some time all databases are updated.

This could be very useful when you have 10 or more instances of database that you want to upgrade.
Steps To ReproduceFrom the tools menu -> Run Script on multiple databases.

A dialog is shown where you enter the script. On the next page you provide some options like : parallel execution, ignore on error, stop on error, transaction options and anything else. Options for parallel execution - number of threads to use.

After starting the process DBW will connect to each database and will run the script.

At the end it will report the status for each connection.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2014-04-01 12:25 Doychin Bondzhev New Issue
2014-04-01 16:21 Martijn Tonies Project Database Workbench v4 => Database Workbench v5
2014-04-02 17:04 Martijn Tonies Status new => acknowledged
2022-01-12 13:15 Martijn Tonies Project Database Workbench v5 => ADS LogManager
2022-01-12 13:15 Martijn Tonies Category General => @1@
2022-01-12 13:16 Martijn Tonies Project ADS LogManager => Database Workbench v6
2022-01-12 13:16 Martijn Tonies Project Database Workbench v6 => Database Workbench v5
2022-01-12 13:16 Martijn Tonies Category @1@ => General
2022-01-12 13:18 Martijn Tonies Project Database Workbench v5 => Database Workbench v6