locked
Copy data from Blob Storage to SQL Database using Data Factory RRS feed

  • Question

  • Hello everybody,

    I am new in azure Data Platform, its possible copy just data that change, or new datas? or Its possible delete all data in destination and copy all data from source?

    I am using this example:

    https://docs.microsoft.com/en-us/azure/data-factory/data-factory-copy-data-from-azure-blob-storage-to-sql-database

    Monday, December 12, 2016 8:17 PM

Answers

  • Actually, copy activity support cleanup your data before execution.

    Just set "sqlWriterCleanupScript" in your activity.

    Details you can see here:

    https://docs.microsoft.com/en-us/azure/data-factory/data-factory-azure-sql-connector#repeatability-during-copy

    • Marked as answer by fit9 Wednesday, December 14, 2016 6:36 PM
    Wednesday, December 14, 2016 7:26 AM

All replies

  • You will need an SPROC Activity. https://docs.microsoft.com/en-us/azure/data-factory/data-factory-stored-proc-activity

    You may run a clean up SPROC Activity before COPY Activity.

    Tuesday, December 13, 2016 1:47 AM
  • Actually, copy activity support cleanup your data before execution.

    Just set "sqlWriterCleanupScript" in your activity.

    Details you can see here:

    https://docs.microsoft.com/en-us/azure/data-factory/data-factory-azure-sql-connector#repeatability-during-copy

    • Marked as answer by fit9 Wednesday, December 14, 2016 6:36 PM
    Wednesday, December 14, 2016 7:26 AM
  • Tks everybody for helping me ..

    I will go test this, tks

    Wednesday, December 14, 2016 6:36 PM