SSISDB to Azure SQL Managed Instance - moving it

Question

Fellow SQL dbas,

I know that SSIS does not function the same way on SQL MI setup like it does with on-premise - use Azure Data factory for SQL MI.

We are migrating to azure. We have SSISDB on one of our on-premise SQL 2016 instances. I would like to know if that can be moved a Azure SQL MI. Thus the application team needs their packages in SSISDB. The SSIS intergartion service will be on an Azure VM. Will the SSIS functionality still be able to pull from the SSISDB from Azure Sql MI?

Is there an issue doing this?

If it is unrealistic, we can keep it on am azure vm like it is today on-premise

Thx

MG

Answer 1

Hi @Mark Gordon,

You may carefully take a reference to this official documentation.

https://learn.microsoft.com/en-us/azure/dms/how-to-migrate-ssis-packages-managed-instance

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.