Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Upgrade from SQL 2008 R2 Dev to 2014 didn't go well. Expand / Collapse
Author
Message
Posted Saturday, May 3, 2014 10:09 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 6:32 PM
Points: 167, Visits: 396
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
Post #1567307
Posted Monday, May 5, 2014 4:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:27 PM
Points: 13,776, Visits: 28,178
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
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1567464
Posted Tuesday, May 6, 2014 8:53 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 6:32 PM
Points: 167, Visits: 396
I'll have to give it another go, Grant, so I can get the error message up again.


Rod
Post #1568267
Posted Tuesday, May 13, 2014 8:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, May 17, 2014 10:18 PM
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!
Post #1570377
Posted Tuesday, May 13, 2014 8:49 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:59 PM
Points: 31,082, Visits: 15,529
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
Post #1570380
Posted Wednesday, May 14, 2014 3:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 10:47 PM
Points: 27, Visits: 79
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
Post #1570697
Posted Thursday, May 15, 2014 5:15 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 6:32 PM
Points: 167, Visits: 396
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
Post #1571250
Posted Thursday, May 15, 2014 5:16 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:59 PM
Points: 31,082, Visits: 15,529
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
Post #1571556
Posted Saturday, May 17, 2014 2:34 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 6:32 PM
Points: 167, Visits: 396
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
Post #1572038
Posted Sunday, May 18, 2014 7:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:27 PM
Points: 13,776, Visits: 28,178
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
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1572073
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse