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 – Franck Dernoncourt Aug 26 '14 at 16:38
  • It's a local H2 database. I added that information to the question. – Kaadzia Aug 26 '14 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. – user3791372 Aug 26 '14 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 '14 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 '14 at 7:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.