Page 1 of 1

External (from a file) script execution

PostPosted: Mon Apr 11, 2011 3:22 pm
by EugeneJF
I have very huge script in a file. And it'll be good not to open it in an editor for execution. Could you add such feature to DBeaver?

Re:External (from a file) script execution

PostPosted: Mon Apr 11, 2011 6:31 pm
by Serge
Generally most databases have their own tools to execute scripts. These tools works much faster than any GUI tool and we can't compete with them. Moreover these tools supports all nuances of local SQL dialects and will parse scripts 100% correctly.
E.g. for MySQL and PostgreSQL you should just execute mysql and pgsql commands with your script file forwarded to standard input.

From the other hand it's often much more convinient to execute scripts from GUI (no need to know a lot of different command line parameters, enter username/password, etc).

But anyway I'm not sure it is a good idea to try to implement universal script executor for now. But we may do it for certain databases for which we have specific plugins. For now it is only MySQL and may be we'll try to include "external" script execution feature in one of following versions. Note that this feature will require installation of local native client.

Note: if this feature will be often requested then may be will try to do some universal script executor.

Re:External (from a file) script execution

PostPosted: Mon Apr 11, 2011 7:44 pm
by EugeneJF

Re:External (from a file) script execution

PostPosted: Mon Apr 11, 2011 8:27 pm
by Serge