Skip to content

A small tool that can run HUGE Microsoft SQL Server script files (of several Gigabytes)

License

Notifications You must be signed in to change notification settings

danarrib/BigSQLRunner

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Big SQL Runner

A small tool that can run HUGE Microsoft SQL Server script files (of several Gigabytes)

Big SQL Runner Main Screen

This simple tool solves a very annoying problem of Management Studio: Open HUGE script files. Microsoft SQL Server Management Studio opens the entire file into memory, and this can be a problem if your file is bigger than the available memory.

Big SQL Runner solves that by reading the input file line-by-line, hence, not having to deal with memory issues. Also, Big SQL Runner runs the file in small chuncks of 300 lines each (this number can be adjusted from 1 to 500000 lines, or 0 to disable chuncks breaking feature). This way each chunck will run fast and it'll allow to track the script execution progress. It also keeps the server running happy if you are not holding any transactions open.

Running

Main features:

  • Can open ANY SIZE of script file.
  • Runs fast, low memory footprint.
  • Breaks the script into smaller chuncks (this feature can be disabled by setting 0 on the corresponding setting).
  • Tracks script execution progress.
  • Calculates remaining executing time (based on average execution speed).
  • Bypasses errors and saves the error chunck lines into a separated file (same name as the input file, but with ".error" extension).
  • Can resume the script execution from a specified line number.
  • Recognizes "GO" statements. GO will make the chunck execute immediately and start a new chunck.
  • It saves the last used connection string on the registry, so next time you open it, the connection string will be there.
  • It's free and open-source.

Instructions:

  • Inform the connection string.
  • Select the script file.
  • Set how many lines per batch program should run.
  • Click "Run Script Now!" button.

About

A small tool that can run HUGE Microsoft SQL Server script files (of several Gigabytes)

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages