>>I have tested on my own test database that when I change a column type from Text to Varchar(max) the content of the column is not lost. But since I am going to do this change on a bunch of customers' databases, is there any chance that the content would be lost?
>>I am changing the type in the SSMS.
>>Thank you.
>
>
>Hi, I would definitely recommend creating a test version of the tables....then change the data type and verify the results.
>
>I'm not specifically aware of any issues - but I would definitely test the results. Also, if there were any client applications that read the data, I'd make sure they still work (just in the odd event a client application was explicitly looking for a text data type)


What about creating an extra column for the varchar(max) and updating it from the text column? when finished, delete text column.