View Issue Details

IDProjectCategoryView StatusLast Update
0000450Database Workbench v5Generalpublic2014-09-09 13:32
ReporterDoychin Bondzhev Assigned ToMartijn Tonies  
Status closedResolutionfixed 
Fixed in Version5.0 
Summary0000450: Simplified SQL script execution interface
DescriptionRight 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.
TagsNo tags attached.


Doychin Bondzhev

2012-10-01 09:00

reporter   ~0000135

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.

Martijn Tonies

2013-08-16 12:10

administrator   ~0000208

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.

Issue History

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