We are adapting our application to use unicode. However, one of our ptoblems is to ocnvert existing data from text to ntext. I couldn't find anything that document this. What is the preferred way to do this? I would like to be able to migrate the data from an existing text column to another ntext column in the table.

If I can't do that, what are the options? Preferrably, I would like to be able to do this in sql script.