I am trying to get a better idea how to execute Visual Studio solution file on a daily basis.
I have a C# Visual Studio (2019) solution that pulls data from a third party (via XML API) and insert data into a local SQL Server Management Studio (SSMS).
Both Visual Studio and SSMS are located in a Azure VM.
I am not sure which way would be the best solution.
Should I use Windows Task Scheduler?
Would be better to program Python or PowerShell?
Should I use Azure DevOps to do the CI/CD?
Thanks.
