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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Data migration from Text column to image column

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