question

DeepakKumarKalyanum-8096 avatar image
0 Votes"
DeepakKumarKalyanum-8096 asked DeepakKumarKalyanum-8096 commented

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

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 .

  1. Is it better to create altogether a new ETL on ADF with pipelines?

  2. Lift and shift this SSIS and execute in Azure SSIS runtime?


Which one is better and any other suggestions ?

Thanks,
Deepak.



azure-data-factoryazure-migrate
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered DeepakKumarKalyanum-8096 commented

Hey @DeepakKumarKalyanum-8096,
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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·