Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Exporting varbinary assets

Author  Topic 

igor22
Starting Member

18 Posts

Posted - 2014-05-30 : 16:11:39
I'm an asp.net developer and I inherited an application that stores all the documents (video,pdf,txt) in a varbinary(max) field.

This is a big headache and I need to move all the files on a NAS

Can anyone point me in the right direction of a tutorial or an example of how to do this without stressing the server? There are about 100000 files stored in the DB.

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2014-05-30 : 16:15:26
probably better to do this with .NET or CLR, but here is a SQL/OLA solution:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=101754

Here is a thread with some options:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/29f30130-3a64-4b91-86b3-5fa09dbc4220/dumping-varbinarymax-column-values-to-files-on-harddisk-using-a-sql-script?forum=transactsql
Go to Top of Page
   

- Advertisement -