Migrate to Azure Managed Instance

Question

Migrate to Azure Managed Instance

JoelP 366

Hi,
We are planning to migrate our SQL On Prem server with SSIS and SSRS to Azure. The option we chose is SQL Managed Instance.

Basically, we are planning on spinning up an SQL Managed Instance to host the DBs, SSIS and SSRS DB but we will have another VM to install the SSRS.

Has anyone done similar setup and can share any issues they encountered.

Also, question re SQL managed instance pricing. I noticed the cheapest plan is 4 core which is around 600 USD. For POC development and testing purposes, we don't want to be paying this monthly. Is there any option to save cost? Do I spin up the instance, and delete it.

JoelP 366 Reputation points

2022-10-19T22:52:42.547+00:00

Also, we are planning on using Azure Migrate for this exercise. Does anyone know how long it take to migrate 150GB database?

Thank you all

1 answer

Your answer

JoelP 366 Reputation points

2022-10-19T22:52:42.547+00:00

Also, we are planning on using Azure Migrate for this exercise. Does anyone know how long it take to migrate 150GB database?

Thank you all

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

Migration time could be a few minutes for that amount of data. I would be surprise if it takes 15-20 minutes. I have migrated 750 GB in about 50 minutes.

The Report Server database can be hosted on Azure SQL Managed instance without any issues while the SSRS is installed on a VM. See SSRS documentation.

About SSIS, SSIS to Azure Data Factory (ADF) or a VM (the SSISDB catalog can be hosted in the managed instance). To “lift and shift” your SSIS-based ETL you need to configure Azure Data Factory (ADF) to host the SSIS runtime. Take in consideration that only SQL Server Management Studio 17.7 and above have support for SSIS package scheduling in SQL Agent on SQL Managed instance. With that version of SSMS or above you can create SQL Agent jobs to execute SSIS packages on the managed instance.

About pricing or discount price for testing, Dev/test pricing is available for SQL Database Managed Instance as part of the Azure Enterprise dev/test offer, providing a cost-effective way to run your development and testing workloads on Azure SQL Database. With dev/test pricing for Azure SQL Database, you can save up to 55 percent versus list prices.

JoelP 366 Reputation points

2022-10-19T23:31:00.237+00:00

Thank Alberto for the quick response.

For SSIS, would it be more expensive if you run it under DF? But again, if we are using the latest one, might as well run it via SQL agent.

Did you use Azure migrate on your migration?
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2022-10-20T02:06:53.427+00:00

If you use SSIS and SSRS, my suggestion is to go with a SQL VM, while balancing memory between SSRS, the database engine and the operating system. To know what means Shift and Lift your SSIS packages, read this article.

I had to use Azure Migration service since using tools like Data Migration Assistant took more than 24 hours to migrate a 750 GB database alone. Migration service makes use of full parallelism.
JoelP 366 Reputation points

2022-10-20T02:39:34.37+00:00

I was in the impression that you can run your SSIS package in SQL Managed Instance

https://learn.microsoft.com/en-us/azure/data-factory/how-to-invoke-ssis-package-managed-instance-agent
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2022-10-20T12:21:48.863+00:00

Yes, you can run SSIS packages using SQL Server Agent on Managed Instance.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-10-21T16:46:42.987+00:00

@JoelP Please let us know if you find the above @Alberto Morillo 's reply useful. If yes, do click on the 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution

Regards
Geetha

Share via

Migrate to Azure Managed Instance

1 answer

Your answer