March 8, 2018 at 10:50 am
I have about 300 odd SSIS packages, about 400 odd SSRS reports and 5 multi dimensional cubes on premise now.
I need to migrate them to Azure. What are the various methods of accomplishing this?
Could I find a document/video which talks in detail about such a requirement.
March 29, 2018 at 2:47 am
I would say a VM with SQL Server would be the best option and probably the easiest as it should cover off all your requirements (SSRS, SSIS & SSAS)
You could go down this route for the cubes https://azure.microsoft.com/en-gb/services/analysis-services
We have never tried it but Data Factories can now handle SSIS package execution https://azure.microsoft.com/en-gb/services/data-factory
When it comes to the SSRS reports, you are back to a VM running SQL Server.
March 29, 2018 at 7:14 am
You're likely going to have to go the route of the VM and just do a full copy/restore to that location. SSIS for example, I believe is still in the works. Last I checked, it was taking 15 to 30 minutes for a single package to execute. I don't know if that has changed lately, but if that's still true then it's likely not an option yet. SSAS and SQL Server both have their Azure components. Don't know if SSRS is there yet. PowerBI would be the other option, but that's another product all together.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply