最佳实施方案:SQL映像数据字节[]到Blob存储 [英] Best Solution to Implement : SQL Image data byte[]'s to Blob Storage

问题描述

我的sql db中有几张图像(超过一百万张)作为byte [].我打算将这些图像移至Blob存储并将URL保存在SQL Server的同一表中.更新我的应用程序以使用URL从Blob获取图像.

I have several images (little over a million) in my sql db as byte[]'s. I am planning to move those images to Blob Storage and save the URL in the same table in my SQL Server. Update my app to get the image from Blob using the URL.

希望这将节省大量昂贵的SQL存储空间，并迈出了第一步.

Hoping this would save a lot of space in my expensive SQL storage and also make the first step to the cloud.

我编写了一个应用程序，该应用程序将从每一行读取每个ImageData字节[]，将其保存到指定容器中的Blob存储中，然后获取URL(保存完成后)，然后使用它.

I have written an app that would read each ImageData byte[] from each row , save it to the Blob Storage in a specified Container and then get the URL (after the save is done) and then update the same table row with it.

我的2000张图像样本大约花了30分钟.

My sample of 2000 images took about 30 min. 

简单的数学计算，整个过程需要大约11-12天的应用程序连续运行(上述场景).寻找更好的解决方案.请告知.

simple math, its going to take about 11-12 days of continuous running of the application (above scenario) for the whole thing to be done. Looking for better solution. Please advise.

谢谢Vijaya Malla.

Thank You, Vijaya Malla.

推荐答案

您可以使用Azure数据工厂将数据从SQL复制到Azure Blob.
有关更多信息，建议您参考 Azure数据工厂.

让我知道是否还有任何需要解决的问题.
-------------------------------------------------- ---------------------------------------------
如果此答案有帮助，请单击标记为答案"或上投票".要提供有关您的论坛体验的其他反馈，请单击此处

You can use Azure Data Factory for copying data from SQL to Azure Blob.
For more information, suggest you to refer Azure Data Factory.

Let me know if there are still any questions I can help with.
-----------------------------------------------------------------------------------------------
If this answer was helpful, click "Mark as Answer" or "Up-Vote". To provide additional feedback on your forum experience, click here

这篇关于最佳实施方案:SQL映像数据字节[]到Blob存储的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！