SSIS migration to azure SQL VM

Question

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

Answer 1

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

Answer 2

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.