Creating a new pipeline or [lift and shift] SSIS - which one is better?

Question

Creating a new pipeline or [lift and shift] SSIS - which one is better?

Deepak Kumar Kalyanum 1

Hello Experts - I would like to understand the best optimal and suitable option or solution here between the 2 :

Scenario : I have an SSIS package with lot of transformations and dynamic data loads on premise and the requirement is to migrate this on premise SSIS ETL to Azure , specifically ADF .

Is it better to create altogether a new ETL on ADF with pipelines?
Lift and shift this SSIS and execute in Azure SSIS runtime?

Which one is better and any other suggestions ?

Thanks,
Deepak.

1 answer

Your answer

Answer 1

Nandan Hegde 36,241 MVP Volunteer Moderator

Hey @Deepak Kumar Kalyanum ,
Is the requirement to just migrate SSIS to cloud or even the database to cloud?
If it is complete migration, I would suggest ADF is the best option .

In case if it is just SSIS migration, then please verify whether all transformations of ssis are readily available in ADF as ADF is still evolving. If all are not available then better to leverage SSIS + ADF for easy migration.

similar thread:
https://stackoverflow.com/questions/65410072/need-inputs-to-decide-azure-data-factory-or-ssis/65411805#65411805

Deepak Kumar Kalyanum 1 Reputation point

2021-05-11T13:56:45.45+00:00

Hello Nandan - Thanks for the revert - I was about to reply back to you when abruptly my system crashed and I had to take meetings through mobile - ok coming back in here.

The second scenario seems the right candidate here - yes we can use a hybrid approach of using both SSIS + ADF - The aim specifically we are looking for is if this is implemented does that bring in more performance compared to on premise SSIS or if this on premise is executed through execute package utility on ADF does that also bring in any performance improvement or creating a new pipeline totally in ADF , that means complete revamp of on premise SSIS to ADF , does this bring in more performance and does this last option need the database to be migrated to cloud as well ? I believe it is not required to migrate the on premise database to cloud.

Thanks and waiting for your valuable suggestions.

Share via

Creating a new pipeline or [lift and shift] SSIS - which one is better?

1 answer

Your answer