Which azure service should I use.

Cherkasov Dmitriy 1 Reputation point
2021-10-06T08:56:46.17+00:00

So I have a pretty big on-premise ssms database and I want to use some data from it in azure Machine Learning.
I need to use just a small amount of data from my db, from certain tables.
Also this data updates from time to time.
I want you to help me with the choice of correct azure service for my purpose.

Azure Database Migration service
Azure SQL Database
Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
2,711 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KalyanChanumolu-MSFT 8,316 Reputation points
    2021-10-06T10:17:26.467+00:00

    @Cherkasov Dmitriy Welcome to Microsoft Q&A forums.

    From the description of your use case, I understand that the database won't be used round the clock but in short bursts of time, when you want to your ML workloads or while updating the tables from your on-premises database.

    You might want to consider Azure SQL Serverless database.
    You will be billed only for the time the database is in use and it automatically pauses itself during inactive periods.

    Please let us know if you have any further questions.

    ----------

    If an answer is helpful, please click on 130616-image.png or upvote 130671-image.png which might help other community members reading this thread.