0

Can we move data from onprem sql server to azure synapse with out using a azure data factory?

My main intention behind this is not to have intermediate storage of data in blob or storage container. the bulk insert works in ADF but do we have any other option here.

James Z
  • 12,209
  • 10
  • 24
  • 44
c.malcolm Richard
  • 21
  • 2

1 Answers1

0

In case if this is a 1 time activity, you can use database migration assistant tool. Else you can also leverage ssis to transfer data between on prem sql and synapse.

Nandan
  • 3,939
  • 2
  • 8
  • 21
  • thansk for the repsonse, but its not a one time activity and its an incremental load – c.malcolm Richard Jan 20 '22 at 14:59
  • Then SSIS can be an option. But you can also prefer to use ADF as there are 3 modes in copy activity to synapse out of which 1 doesn't need blob – Nandan Jan 20 '22 at 16:24