Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004

    Red face Unanswered: Export data onto Hard Disk

    Hello People,

    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.....

    Many Thanks,


  2. #2
    Join Date
    Nov 2002
    bcp, DTS?

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    You can 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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts