September 20, 2016 at 4:18 pm
Hi,
I am new to Azure and looking for the best option possible to move data from different SQL server and Project Server database to our new Azure database. As of now in our reporting SQL database we are using SSIS 2012 to feed data in . Is it possible to run SSIS in Azure or there are other best ways possible ?
Thanks,
Plabita Baruah
September 21, 2016 at 1:21 am
There's no real SSIS as a service in Azure.
You can host a machine in Azure though and install SSIS on it, just like on any regular virtual machine.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 21, 2016 at 4:56 am
How about data factory?
September 21, 2016 at 5:45 am
BLOB_EATER (9/21/2016)
How about data factory?
I noticed you can now access on-premise data as well using the data management gateway, so maybe I was a bit too quick to say there's no real SSIS as a service.
Still think though that data factory is more meant for big data/cloud solutions and that SSIS is still another beast (different scale).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply