SSISDB to Azure SQL Managed Instance - moving it

Mark Gordon 901 Reputation points

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



SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,583 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,446 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 32,401 Reputation points

    Hi @Mark Gordon,

    You may carefully take a reference to this official documentation.


    Zoe Hui

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

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful