John Baird
Coatesville, Pennsylvanie, États-Unis
Information générale
Forum:
Microsoft SQL Server
>>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement