Hi there!
At my work, we have many databases on a server. I have to make an application so that the users can run SQL scripts from the application on a chosen database.
So my question can be seperated in 2 sections:
1- Is there a way to let the users run SQL scripts directly from the application?
I am thinking about creating a page showing a list of all the SQL scripts we wanna use and, when clicking on a specific script name in the list, it would ask something like "On which database do you want to run the script?", and then, as the user confirms a database, it would show the script's running results on a different page.
2- Is there a way to let the users choose on which database to run those scripts?
Any tip would help, I'm at the start of the project and am not sure at all about how to accomplish this, or if it is possible at all.
Thank you!