var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Export data onto Hard Disk
I have began to store binary data in my database, for example word documents, PDF's....etc.
But now my database file is growing beyond what I want, and I need to move all of the files out of the DB onto normal hard disk space.
Is there anyway, say by using a bulk copy command, that I can write all the contents of the table into a folder on my hard disk...???
My database table consists of ID(int), Filename(varchar), Filetype(varchar), Filesize(varchar), Filebody(image)
Any help would be extremely appreciated.....
BCP the entire contents of a table into a single file on your hard disk. You could write a DTS package that took every row from your table, and wrote the contents of the filebody column into a file named by the filename column.