Currently we have integrated Redgate to provide us SQL Compare scripts, we need to download the scripts and run it in Microsoft SQL Server., is there any way that I can octopus directly executes the SQL file in the SQL server without manual intervention
You can install these step templates directly in your web portal and configure them as needed in your project. You can also modify the source code if needed at any point.
Let me know how you go or if you have any further questions moving forward!