Dear 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.

Is there any method to do it..

Thanks

If you are using SQL server then

text
Variable-length non-Unicode data in the code page of the server and with a maximum length of 2^31-1 (2,147,483,647) characters. When the server code page uses double-byte characters, the storage is still 2,147,483,647 bytes. Depending on the character string, the storage size may be less than 2,147,483,647 bytes.

image
Variable-length binary data from 0 through 2^31-1 (2,147,483,647) bytes.
I think conversion from text to image data type is not allowed in SQL
text and image Data Types

Automatic data type conversion is not supported for the text and image data types.

You can explicitly convert text data to character data, and image data to binary or varbinary, but the maximum length is 8000 bytes. If you try an incorrect conversion such as trying to convert a character expression that includes letters to an int, SQL Server returns an error message.

__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.

Thanks om_prakash
Tried converting text to varchar(8000) and then to image.
It is working,but my text column contains more than 8000 characters.

So now i am trying to write an application , which reads data , convert and then insert to table.

Any possibilities are there within sql 2000?
(using file system object or so...)

Any good links , for the usage of file system object..

Hi,
Please check the following link for usage of filesystem object in ASP:
http://www.w3schools.com/asp/asp_ref_filesystem.asp

__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.

But i am checking whether it is possible with some SP which uses File system object
like
EXEC @hr = sp_OACreate 'Scripting.FileSystemObject', @ole_FileSystem OUT

If you want to export some data into flat files, then you can use DTS for this.

http://msdn.microsoft.com/en-us/library/cc917688.aspx

Other links which will be helpful..

http://vstoolsforum.com/blogs/sqlser...rver-2000.aspx
http://www.mssqlserver.com/faq/general-flatfile.asp

__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.