Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Upgrade from SQL 2008 R2 Dev to 2014 didn't go well.


Upgrade from SQL 2008 R2 Dev to 2014 didn't go well.

Author
Message
Doctor Who 2
Doctor Who 2
SSC Veteran
SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)

Group: General Forum Members
Points: 287 Visits: 595
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
Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17586 Visits: 32265
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

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Doctor Who 2
Doctor Who 2
SSC Veteran
SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)

Group: General Forum Members
Points: 287 Visits: 595
I'll have to give it another go, Grant, so I can get the error message up again.

Rod
webappenthu
webappenthu
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 5
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!
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36113 Visits: 18742
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.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
girijesh.ipec
girijesh.ipec
Valued Member
Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)

Group: General Forum Members
Points: 74 Visits: 103
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
Doctor Who 2
Doctor Who 2
SSC Veteran
SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)

Group: General Forum Members
Points: 287 Visits: 595
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
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36113 Visits: 18742
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.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Doctor Who 2
Doctor Who 2
SSC Veteran
SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)SSC Veteran (287 reputation)

Group: General Forum Members
Points: 287 Visits: 595
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
Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17586 Visits: 32265
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

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search