locked
ADFS - Onprem SQL Filestream data to Azure Blob storage RRS feed

  • Question

  • Hello, Is it possible to use ADFS to move onPrem SQL Filestream data to Blob storage?

    I am using Copy data to move few tables and want to use same pipeline to move Filestream data copied to Blob storage. Let me know whether it is possible using Custom or Azure function in the pipeline to achieve this?

    THank you


    Ram

    Tuesday, March 24, 2020 1:35 PM

All replies

  • Hello Ram , 

    In SQL filestream data stored in binary format and at this time Azure data factory does not support that . The support data type are called out here .

    https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-schema-and-type-mapping#data-type-mapping

    Since using cutom activity , we basically run our code on Azure batch , though I have not tried that , but I think that should be the way to go .


    Thanks Himanshu

    Tuesday, March 24, 2020 10:10 PM
  • Hello , 

    We have not received a response from you.  Are you still facing the issue?  If you found a solution, would you please share it here with the community?  Otherwise, let us know and we will continue to engage with you on the issue.


    Thanks Himanshu

    Thursday, March 26, 2020 5:43 PM