May 3, 2014 at 10:09 pm
I have SQL Server 2008 R2 Developer Edition installed on my development box. I purchased SQL Server 2014 Developer Edition and was trying to do an upgrade. The upgrade didn't go well at all. I tried downloading the Upgrade Advisor, but that didn't work, because it wanted something else. The link pointed to by the setup didn't work, it pointed to a page that isn't there. So then I decided to download the whole Microsoft® SQL Server® 2014 Feature Pack, and it started installing a boat load of stuff in, well I'm not sure what order. That didn't go well either, and I'm sure it's because whatever it needs to install wasn't being installed in the order that it needs to be installed in.
So, I'm not sure where I stand at the moment.
I just got into SSMS 2008 R2 and took a quick look at a table. It's still there, so I guess I've not lost anything.
So, I need help in finding out how to properly install SQL Server 2014 Developer Edition, trying to do an upgrade from SQL Server 2008 R2 Developer Edition. What software packages need to be installed so that the Upgrade Advisor can work? And what order should they be installed in?
Rod
May 5, 2014 at 4:47 am
Ignore all the other stuff you were attempting to install. The Upgrade Advisor is just to check your databases to ensure they can be upgraded. The pack is just some additional tooling. To do the upgrade, just focus on SQL Server.
Now, you said "something was missing." Did that come up in an error message? If so, what was the specific error message of what was missing? That's going to tell you what you have to have to get the upgrade done. I just recently did several upgrades with no issues. It's just a question of following the prompts on the screen.
But knowing the specific errors might help us help you.
"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
May 6, 2014 at 8:53 pm
I'll have to give it another go, Grant, so I can get the error message up again.
Rod
May 13, 2014 at 8:46 am
Hi,
I am not sure how much of SQL Server 2014 you already know but if you are a beginner like me there are some awesome free tutorials out there which help you through the process of installation:
https://www.youtube.com/watch?v=EVjyKSCo3vs (video)
http://www.sqlserver2014tutorial.com/
Hope this helps!
May 13, 2014 at 8:49 am
Once you complete the install, you can search the entire system for the most recent modified files. There is a setup log you can review to see what happened.
I tried to go from 2012 -> 2014. Two of the VMs worked, one didn't. However it's gotten me concerned about upgrading any more. I am looking at new installs as named instances, or uninstall/reinstalls for me.
May 14, 2014 at 3:39 am
You should look for new installs as named instances, or uninstall/reinstalls. hope this should work fine.
I tried it worked for me.
Regards,
Girijesh
May 15, 2014 at 5:15 am
Steve Jones - SSC Editor (5/13/2014)
Once you complete the install, you can search the entire system for the most recent modified files. There is a setup log you can review to see what happened.I tried to go from 2012 -> 2014. Two of the VMs worked, one didn't. However it's gotten me concerned about upgrading any more. I am looking at new installs as named instances, or uninstall/reinstalls for me.
I wonder if I shouldn't do that. Back up all of my databases, do an uninstall and then a reinstall. Maybe that would be better.
Rod
May 15, 2014 at 5:16 pm
I might. It's quick and easy, and its certainly less frustrating then having errors pop up or one of my instances fail to restart.
May 17, 2014 at 2:34 pm
Steve Jones - SSC Editor (5/15/2014)
I might. It's quick and easy, and its certainly less frustrating then having errors pop up or one of my instances fail to restart.
I'm thinking of doing an uninstall of 2008 R2, install of 2014 this weekend. This is of the Developer Edition. My inclination is to detach the databases I have, uninstall 2008 R2, install 2014, then attach the .MDF/.LDF files. Does this seem reason to you, Steve? (And everyone else.)
Rod
May 18, 2014 at 7:05 am
Yeah, seems reasonable. On my dev machine I just installed it right over the top of 2012 with no issues. Just so you know.
"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
May 18, 2014 at 1:44 pm
Grant Fritchey (5/18/2014)
Yeah, seems reasonable. On my dev machine I just installed it right over the top of 2012 with no issues. Just so you know.
I think I'll try the uninstall of 2008 R2, and install of 2014. When I tried installing 2014 over the top of 2008 R2 it didn't work. Fortunately, it left it alone. The only problem is trying the time to get it done. I want to work with 2014; keeping my skills up and so on. However, as I've mentioned elsewhere my position is being downsized soon, so much of my time is just spent looking for other opportunities.
Rod
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply