SSIS migration to azure SQL VM

SaikrishnaE 51 Reputation points
2022-10-28T15:31:59.73+00:00

Hi,

i wanted to migrate my onpremise SQL Server(SQL 2014) to SQL server on Azure VM(2019), i have SSIS packages on my onprem SQL server. How can i migrate them to Azure SQL VM.

Thanks

SQL Server on Azure Virtual Machines
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,493 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
506 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Ronen Ariely 15,091 Reputation points
    2022-10-28T15:43:00.017+00:00

    Hi,

    There is no different between this and migrate between two on-premises servers. The SQL server on Azure VM is just behave and control like any SQL server on premises in this task.

    The question could be more complex and interesting of you wanted to migrate from on-premises to Azure Database or to Azure managed instance :-)

    The following post will help you run SSIS on Azure VM (IaaS)

    https://techcommunity.microsoft.com/t5/sql-server-integration-services/running-ssis-on-azure-vm-iaas-do-more-with-less-money/ba-p/388328?WT.mc_id=DP-MVP-5001699

    0 comments No comments

  2. ZoeHui-MSFT 34,591 Reputation points
    2022-10-31T05:36:43.91+00:00

    Hi @SaikrishnaE ,

    Please refer to sql-server-to-sql-on-azure-vm-individual-databases-guide.

    You may also check running-ssis-in-an-azure-vm.

    Regards´╝î

    Zoe Hui


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

    0 comments No comments