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 |
|
Jomet
Starting Member
1 Post |
 Posted - 2009-09-18 : 00:59:55
|
Hi friends,
My old db contains a text column.
In my new db it is image datatype.
I want to migrate my old data to new db.
Tried converting text to varchar(8000) and then to image.
It is working,but my text column contains more than 8000 characters.
now i am trying with file system object..
But i am new to it..
Is it possible to temp create a file using the data in the text column and then inserting back as binary data??
Any methods to do it
-Jomet |
|
|
|
|
|
Data migration from Text column to image column