SSISDB to Azure SQL Managed Instance - moving it

Mark Gordon 901 Reputation points
2023-03-15T15:15:06.6666667+00:00

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

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
    2023-03-16T01:29:01.47+00:00

    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful