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

__________________
jomet.
`````````````````````````````````````````````````` ``````````````````````
Once you start a working on something, dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.

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

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.

__________________
jomet.
`````````````````````````````````````````````````` ``````````````````````
Once you start a working on something, dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.

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

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

__________________
jomet.
`````````````````````````````````````````````````` ``````````````````````
Once you start a working on something, dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.

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

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

__________________
jomet.
`````````````````````````````````````````````````` ``````````````````````
Once you start a working on something, dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.

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