This is SQL 2014
We have a table with 3 Text fields. It holds data that has been compressed in .Net code. Not encrypted, it's compressed and .Net code decompresses the data to display on the screen.
It looks like this
I don't know if we'll lose the data but can I change Text field to nvarchar(max) without losing data?