Share via

Can Azure Migrate handle other SQL Server components?

Abimbola Adeniran 46 Reputation points
2024-02-26T17:48:38.31+00:00

Hello, I have just started to work on a migration project for a client that has the current onpremise environment on Win/SQL 2012 and want to replatform (migrate & upgrade) to Win/SQL 2019. They have cubes (SSAS), Reports (SSRS) and SSIS that need to be migrated and upgraded as well so I would like to know if Azure Migrate can handle migration with these requirements. I know it can handle disco, assessment and migration for the actual onpremise databases but not sure of the other SQL Server components mentioned. If Azure Migrate can, how is it done? If not, what are the other options?

Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
819 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,045 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,944 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,600 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,291 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Marcin Policht 26,385 Reputation points MVP
    2024-02-26T21:29:01.8266667+00:00

    Yes - that's supported as per https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/virtual-machines/sql-server-to-sql-on-azure-vm-migration-overview?view=azuresql |Lift & shift|Use the lift and shift migration strategy to move the entire physical or virtual SQL Server from its current location onto an instance of SQL Server on Azure VM without any changes to the operating system, or SQL Server version. To complete a lift and shift migration, see Azure Migrate.The source server remains online and services requests while the source and destination server synchronize data allowing for an almost seamless migration.|Use for single to large-scale migrations, even applicable to scenarios such as data center exit.Minimal to no code changes required to user SQL databases or applications, allowing for faster overall migrations.No extra steps required for migrating the Business Intelligence services such as SSIS, SSRS, and SSAS.| | -------- | -------- | -------- | |Lift & shift|Use the lift and shift migration strategy to move the entire physical or virtual SQL Server from its current location onto an instance of SQL Server on Azure VM without any changes to the operating system, or SQL Server version. To complete a lift and shift migration, see Azure Migrate.

    The source server remains online and services requests while the source and destination server synchronize data allowing for an almost seamless migration.|Use for single to large-scale migrations, even applicable to scenarios such as data center exit.

    Minimal to no code changes required to user SQL databases or applications, allowing for faster overall migrations.

    No extra steps required for migrating the Business Intelligence services such as SSIS, SSRS, and SSAS.|

    hth Marcin

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.