Header banner
Revain logoHome Page
Virgilio Patton photo
1 Level
840 Review
41 Karma

Review on Microsoft SQL Server Integration Services to Alation by Virgilio Patton

Revainrating 5 out of 5

SQL Server Integration Services Migration Tool

This tool is very useful for ETL process, it can be used as data warehouse solution or database migration from one platform to another such like Oracle/SQL server etc. It has some limitations in terms of performance but we have managed by tuning parameters accordingly. Also I would recommend this product because its easy integration with SSIS packages which helps me doing my job easily. We are using sqlserver 2016 at our office location so i think that's why there might be little limitation compared to other versions. If you want to migrate your existing databases then use MSSQLIntegration services otherwise if you just need an efficient way of transferring tables between different platforms (Oracle & MS-sql) try out this software. For migrating large amount of data into new system without any problem.

img 1 attached to Microsoft SQL Server Integration Services to Alation review by Virgilio Patton



Pros
  • Easy interface
  • User friendly environment.
  • Can perform multiple task within single project
Cons
  • Some little things