Copy files from on-prem to azure

0
votes

I'm new to Azure eco system. I'm doing some research on copying data from on-prem to azure. I found following options:

  • AzCopy
  • Azure Data Factory (Copy Data Tool)
  • Data Management Gateway

Ours is a Microsoft shop; so, I'm looking for tools that gel with MS platform. Also, down the line, we want to automate the entire thing as much as we can. So, I think, Azure Storage Explorer is out of the question. Is there a preference among the above 3. Or, are there any better tools?

2
azureazure-sql-databaseazure-data-factoryazcopy
The question is what's the destination? Are you trying to copy data from on-premises to Azure Storage or Azure Data Lake? – Gaurav Mantri
Thank you Gaurav. For now, I'm looking at Azure blob storage. – RaviLobo

2 Answers

2
votes

I think you are mixing stuff, Copy Data Tool is just an Azure Data Factory Wizard to make some sample data moving between resources. Azure Data Factory uses the data management gateway to get on premises resources such as files and databases.

What you want to do can be made with Azure Data Factory. I recommend using version 2 (even in its preview version) because its Authoring is easier to understand if you are new to the tool. You can graphically configure linked services, datasets and pipelines from there.

I hope this helped, if you need further help just ask away!

0
votes

If you're already familiar with SSIS, there's also the option to use SSIS in ADF that enables on-prem data access via VNet.