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.
| Author |
Topic |
|
chris_wood99
Yak Posting Veteran
70 Posts |
 Posted - 2011-06-29 : 04:32:21
|
| Hi,We have a database on SQL 2008 R2 that contains a field in a table that is of 'image' datatype. I am attempting to script this data out of this table, but sql server export is failing without an error. I have also attempted to change the image field to a varbinary(max) but this cannot be done without droppind and recreating the table, so im back to needing to script out the data.Any suggestions or tools would be much appreciated.Chris |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-06-29 : 04:40:57
|
Just an idea:Add a new column of type varbinary(max)update the new column with the data from the image columndrop the image columnrename the new column to the old name of the deleted image column
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Exporting data from image datatype