I have a SQL script that is too large to run it in my usual DB tool (dbvisualizer). Unfortunately I don't have access to the purchase version of dbvisualizer which would allow me to run large scripts in the command line tool.

What is a good free tool to run a large SQL script in?

In my case large means: script file >200MB, 1 CREATE statement and lots of INSERTs. Intended to be run on a local H2 database.

  • 4
    Fot which DBMS? Most (all?) of them provide a CLI e.g. dev.mysql.com/doc/refman/5.5/en/mysql-batch-commands.html Aug 26, 2014 at 16:38
  • It's a local H2 database. I added that information to the question.
    – Kaadzia
    Aug 26, 2014 at 16:59
  • 1
    Cut the sql file up into small chunks. If there are lots of inserts, split the file up into 4 50MB files or so. To get acccess to the "purchase version", you can purchase it. Aug 26, 2014 at 19:37
  • 3
    You want to run a 200Mb script, presumably with the blessing of your employer, and he doesn't want to pay for it? (Shakes head) So how much time are you going to waste (at what $ rate), before your employer buys you the tool instead of wasting his money avoiding the obvious solution?
    – Ira Baxter
    Sep 3, 2014 at 3:14
  • 1
    Ira, if you are suggesting, that this is short sighted and a total waste of time and money, you are so right. Unfortunately there are companies were "this is not in our tool chain" is more important than "this would be the most efficient (and cheapest) way to do this."
    – Kaadzia
    Sep 3, 2014 at 7:33


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.