I need to run multiple SELECT queries on a SQL database. I know I can include multiple queries separated by a semicolon, but if I run too many of these the session will timeout. I'm using DBVisualizer 11.0.6.
Each query is different, and some are more complex than others. I have about 100 in total. It is time consuming to run them individually, or even 5 at a time.
Do you have any suggestions to make this process faster? Or any suggested tools I should be using instead of DBVisualizer? Ideally it would be great if I could run them all at once, and view the results in some sort of report or spreadsheet.
Thank you!