View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000862 | Database Workbench v6 | General | public | 2014-04-01 12:25 | 2022-01-12 13:18 |
| Reporter | Doychin Bondzhev | Assigned To | |||
| Priority | normal | Severity | feature | Reproducibility | N/A |
| Status | acknowledged | Resolution | open | ||
| Product Version | 4.4.5 | ||||
| Summary | 0000862: Execute single SQL Script to multiple database connections | ||||
| Description | There 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 Reproduce | From 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. | ||||
| Tags | No tags attached. | ||||
| 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 |
