upgrade from 2008 to 2014

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

dbafromthecold@gmail.com SSChampion Points: 10160 More actions · Answer 1

Yes you can install SQL 2014 next to SQL 2008 and then restore the database.

Just remember to run the SQL upgrade advisor to make sure there won't be any problems with the restore.

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 2

Just know that installing them side-by-side on the same server, for a time, while both are running, they're likely to be competing for resources.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

arkiboys Hall of Fame Points: 3958 More actions · Answer 3

Hello ,

does the 2014 enterprise edition include the business intelligence too? so that I can migrate the ssis and ssrs from the previous versions?

thanks

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 4

Yes. SQL Server hasn't fundamentally changed.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Summer90 SSC-Dedicated Points: 32891 More actions · Answer 5

If you are manually upgrading the dbs remember to script out logins, SQL Agent jobs and any linked servers.

Also, run a Check Integrity and rebuild indexes after you upgrade the dbs to 2014.