How to execute SQL queries from text files

Question

I am using Aqua Data Studio 7.0.39 for my Database Stuff. I have a 20 SQL files(all contains sql statements, obviously).

I want to execute all rather than copy-paste contains for each.

Is there any way in Aqua to do such things.

Note: I am using Sybase

Thank you !!

Answer 1

I'm also not sure of how to do this in Aqua, but it's very simple to create a batch/powershell script to execute .sql files

You can use the SAP/Sybase isql utility to execute files, and just create a loop to cover all the files you wish to execute.

Check my answer here for more information: Running bulk of SQL Scripts in Sybase through batch