[Cause and Resolution] Cause: After migrating data, hyperlinks in columns lose their functionality and become simple nvarchar(max) columns. Resolution: None. [Issue] 
Hyperlink functionality is lost after migrating data.