Search code examples
oracleautomationoracle-sqldeveloper

How can I accomplish the automatic execution of many scripts on many databases in SQL Developer?

Some Sprints we need to take many (sometimes 20+) different P-SQL Scripts and execute all of them on multiple Databases (dev,test,demo,etc...).

I need to automate this or else I'll go insane.

I tried creating a Job, but It doesn't seem to work like I want it to. My idea was to let it point to the (local) repo/folder where the scripts are and run them for each Database.

Using SQL Developer for this Task is no priority, but it would be nice if I could make it work without using some other software.

Solution

  • We now settled for a PowerShell Script using SqlPlus. For anyone interested, this is the Tutorial I used to make it work: https://codingbee.net/powershell/powershell-run-sql-queries-using-sqlplus