Post reply

How to export a table with binary data (image)????

  • August 16, 2006 at 2:57 am

    #116059

    Hi, which is the best method to export a table with image(binary) datatype?

    I want to import this table into an isolated SQL Server (not connected to the network)

     

    Thnaks a lot!!!!

     

  • August 17, 2006 at 7:16 am

    #655441

    The only thing I can think of is to make a backup of the db, restore it (on the source machine), then remove all the tables EXCEPT the one you want moved. Make a backup of this 1-table db, burn it to cd or dvd, then restore it to the isolated sql server.

    This seems like a round-about method to move it, but would work. Anyone have better ideas?

    James

  • August 17, 2006 at 7:25 am

    #655442

    Thanks JB,  your answer is a valid method, but I can't believe that sql server does not have instruments in order to export one table with binary columns.

     

    Bye

  • August 17, 2006 at 8:15 am

    #655460

    I did a little more digging, and it looks like bcp can do what you're wanting.

    http://msdn2.microsoft.com/en-us/library/ms191232.aspx

    This should be a little easier than the method I outlined above.

    James

  • August 18, 2006 at 2:40 am

    #655586

    bcp with "-n" argument works fine for me.

    Thanks a lot!!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply