I need to run the same 3 SQL scripts (SQL1, SQL2 and SQL3) on 1 to 4 identical databases. The number of databases varies and is found by querying a DBMaster database : select Source_data from COMPANY. This query returns the name of the databases where the scripts should be executed.
There is at least 1 database found: LOCAL_1. But we can also have LOCAL_2, LOCAL_3 and LOCAL_4.
So, for each database found from the above query, I should run SQL1, SQL2 and SQL3 in this order. Il one of them fails, the installation should abort.
Any help is welcome!
FOLLOW US
Get the latest news in Application Packaging