Migrating an automated web App with Python scripts and connection to on-prem DB

Question

We have a test tool that compares data stored in SQL tables from multiple sources, some on-premise, some in the cloud. The connection strings, test configurations and test results are all stored inside SQL tables. The tool consists of a backend, a frontend and several Python scripts for computation. The Python is called from a batch script arranged by the Windows scheduler look at a test configuration table every minute to run scheduled test suites at that minute. Thousands of automated tests are carried out by this tool every day.

What would be the best service/approach to move this tool using Azure services? The main aim is just to escape from the Windows scheduler and make it into cloud.

Thank you!

Answer 1

@Ash Peng Thanks for reaching out. Azure offers different services with different workloads. You can always refer to the compute discission tree to validate which would be better service for your load/use case and how you want to migrate the service to cloud.

In short if you have event driven workload with short lived process then you can choose azure function as I am not sure for how long your individual thousand of services would run. You can create a Python function that runs your automated tests, and configure the function to be triggered by a timer or other event.

Other option could be Azure batch if you have HPC workload for your automation scripts that is compute intensive works.

If you want to migrate and change it to containerized service then you also review azure container apps.

I will suggest to review this document and then choose the right service for your workload.