View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000450 | Database Workbench v5 | General | public | 2012-09-28 11:21 | 2014-09-09 13:32 |
| Reporter | Doychin Bondzhev | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | feature | Reproducibility | N/A |
| Status | closed | Resolution | fixed | ||
| Fixed in Version | 5.0 | ||||
| Summary | 0000450: Simplified SQL script execution interface | ||||
| Description | Right now to execute a sql file against database you must open it in SQL editor. This editor has big performance problems with large SQL files. I'm proposing to have another way to execute SQL files. Instead of opening and running from SQL editor to have new menu option - Run SQL file. It can be in Tools menu. From there you select the SQL file and new window is displayed with progress bar and single text line where the last executed line number is displayed. I suppose this will be much more faster and will take less CPU resources to refresh UI. | ||||
| Tags | No tags attached. | ||||
|
|
One more thing to this request. Usually this will be used to restore for example MySQL databases from large SQL files. In this case there is no guarantee that in this SQL file tables are deleted before executing create table statements. So maybe a wizard where you can tell which tables to drop/empty before execution will be very useful. |
|
|
Hello Doychin, That wizard doesn't make sense to me, as this new functionality involves running any large script. Perhaps this (later) can be extended to an option on the Script Runner, but for now, no. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-09-28 11:21 | Doychin Bondzhev | New Issue | |
| 2012-10-01 08:49 | Martijn Tonies | Status | new => acknowledged |
| 2012-10-01 09:00 | Doychin Bondzhev | Note Added: 0000135 | |
| 2013-05-01 14:22 | Martijn Tonies | Project | Database Workbench v4 => Database Workbench v5 |
| 2013-08-07 16:19 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2013-08-07 16:19 | Martijn Tonies | Status | acknowledged => assigned |
| 2013-08-16 12:10 | Martijn Tonies | Note Added: 0000208 | |
| 2013-08-16 12:11 | Martijn Tonies | Status | assigned => resolved |
| 2013-08-16 12:11 | Martijn Tonies | Fixed in Version | => 5.0 |
| 2013-08-16 12:11 | Martijn Tonies | Resolution | open => fixed |
| 2014-09-09 13:32 | Martijn Tonies | Status | resolved => closed |
