The early days of SQL Server Azure PaaS offerings were a period of change for Data professionals, DBAs etc. As a lot of colleagues and end users remarked “Where is the SQL Agent? Life simply isn’t the same anymore!”
For purpose of this demonstration, I have created ADF pipeline to copy all tables from SQL database onto blob storage.
I have pipeline developed in adf-demo-dev1 Data Factory and will be deploying code to “adf-demo-uat” and “adf-demo-prod” Data Factories:
Many businesses who are planning to migrate to Azure, see Azure SQL Database Managed Instance as a simple way to make the transition and there is good reason for this. It’s a great product with a lot of positive features. However, at this point in time, Azure Managed Instance has some key limitations that could mean it is not an option for your project.