阅读背景:

将blob从表导出到单个文件的最快方法

来源:互联网 

What is the fastest way to export files (blobs) stored in a SQL Server table into a file on the hard drive? I have over 2.5 TB of files (90 kb avg) stored as varbinary and I need to extract each one to a local hard drive as quickly as possible. BCP seems to work but it will take over 45 days with the speed I'm seeing, and I'm worried that my script will fail at some point because Management Studio will run out of memory.What is the fastest way to export files (blobs)




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: