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 |
|
madhav20
Starting Member
6 Posts |
 Posted - 2011-10-10 : 14:16:05
|
| Dear experts, I had a requirement to transfer data from image field from one sqlserver 2008 database to an ntext field in another database on the same server using SQL Queries. I am getting errors while doing direct coversion/casting."Explicit conversion from data type image to ntext is not allowed." Is there any other way to transfer data from image to Ntext filed?Thank you. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-10 : 14:36:52
|
| why are you using ntext,image etc. do you know that these are deprecated ones. If possible, try to use nvarchar(max),varbinary(max) etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
madhav20
Starting Member
6 Posts |
Posted - 2011-10-10 : 14:46:44
|
quote:
Originally posted by visakh16
why are you using ntext,image etc. do you know that these are deprecated ones. If possible, try to use nvarchar(max),varbinary(max) etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
Hi, Thanks for your quick reply.Our application created 10-12 years back. Our business and dev team dont want to change it now. We are doing data migration from another application(database, here datatype is image) to our application(database, here datatype is ntext).Please help me if there is any way to move image data to ntext field. Thanks. |
|
|
|
|
|
|
Transfer data from Image field to Ntext field