PHISSUG

Hello,

I have a table that contains an Image datatype column.  I am soliciting for implementations on how to transfer the data on this column to another table that has the same schema.

Suppose "table1" is the name of the original table with Image datatype and "table2" is the table of the schema as "table1".

In my current implementation, what I did is something like (pseudocode)

1. SELECT * FROM table1
2. Saved the result in a strongly typed dataset with datacolumn for the image column as System.Byte. I tried the System.Type.GetType("SqlDbType.Image") but it didn't work.
   
3. Created an SP that will write this to "table2" but it didn't work as expected.
   

Suggestions?

 

have you tried the import/export wizard?

is this a one time solution or something more recurring process?

I'm doing this for a tool that I am making. :)

I can say that this is recurring as far as the tool is invoked to work. 

it could be done via SSIS and run it as a scheduled job if it is recurring and if 2 sql servers have direct links with one another. :)

use import/export wizard. there is an option there to save the package. Then integrated the saved package in your tool.