Just after a new release of SQL Server 2008 R2, Microsoft advises customers that have been testing the CTP releases of SQL Server 2008 R2 should resist the temptation to upgrade to RTM, and instead re-deploy from scratch; “Right up until the last minute, things are changing in the code – and you want that to happen. Our internal testing runs right up until the second we lock down for release, and we watch the CTP/RC/Beta reports to make sure there are no show-stoppers, and fix what we find. And it’s not just “big” changes you need to worry about – a simple change in one line of code can have a massive effect,” Buck Woody revealed. “Even if you’ve done this before and things seemed to go well, you may be in a difficult situation because of it – if you are a “TAP” customer (you’ll know if you are), we help you move from the CTP products to RTM, but that’s a special case that we track carefully and send along special instructions and tools to help you along. That level of effort isn’t possible on a large scale, so it’s not just a magic tool that we run to upgrade from CTP to RTM. So again, unless you’re a TAP customer, it’s a no-no,” said Woody.