April 28, 2014 at 2:13 am
After the testing you can change the compitability level of the database to 2014. Also you can use sp_help_revlogin to migrate users. There are two aproach to the upgrade one is side-by-side and other is in-place upgrade.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2014 at 4:22 am
Since it's a dev box, I'd just do an in-place upgrade. I recently did one for my 2012 system to move it to 2014. It just worked. You do have to remember to change the compatibility level on your databases, but that's about it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 28, 2014 at 9:53 pm
Thank you free_mascot and Grant.
Rod
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply