View Single Post
Old 2016-08-23, 16:41   #1111
If I May
chalsall's Avatar
"Chris Halsall"
Sep 2002

100100011000102 Posts

Originally Posted by Madpoo View Post
But even that means making sure any updates/inserts aren't using implicit column placements... I'm pretty sure anything like that is explicitly handled (as far as I've seen, that's the case) but Murphy's law says there'd be that one exception where an insert assumes columns are in a certain order and doesn't spell 'em out.
Implicit column placements... Shutter....

Your planned migration sounds sane. Add the new column at the end of the table and the worst case will be the new nvarchar column isn't updated by any legacy code doing implicit references.
chalsall is online now   Reply With Quote