What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.
Course Of The Month
3 days, 2 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SQL Upgrade 2008 to 2012
Posted on 2013-12-04
Hi,
We are currently in progress of upgrading our new web-apps to take advantage of .net 4.5
As it stands we can just mount our current sql 2008r2 databases into SQL 2012 and all will work fine after our tests. The question is, should we also rebuild the database directly in 2012 rather then 're-moun' the old ones? Are there any differences to building it fresh in 2012?
Performance? Optimisations? Features?
or is it just a waste of time and go ahead and mount the 'older' 2008 r2 databases?
Thanks!
We are currently in progress of upgrading our new web-apps to take advantage of .net 4.5
As it stands we can just mount our current sql 2008r2 databases into SQL 2012 and all will work fine after our tests. The question is, should we also rebuild the database directly in 2012 rather then 're-moun' the old ones? Are there any differences to building it fresh in 2012?
Performance? Optimisations? Features?
or is it just a waste of time and go ahead and mount the 'older' 2008 r2 databases?
Thanks!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
3
7 Comments
Just to avoid misunderstandings: you have one server (call it 1st) with SQL2008R2 and another server (call it 2nd) with SQL2012. Correct?
If this is it, I would mount the DBs into SQL2012. I see no need to "rebuild".
Take care of the compatibility level of each DB.
If this is it, I would mount the DBs into SQL2012. I see no need to "rebuild".
Take care of the compatibility level of each DB.
Yes that's correct.
My developers were saying that just mounting it may not bring all the optimization a that rebuilding it in SQL 2012 would do.. I'm not too sure about databases but they have no problems just mounting it. It was just advice that it would probably be better in the long run to have it built straight up using 2012.
Is this true?
My developers were saying that just mounting it may not bring all the optimization a that rebuilding it in SQL 2012 would do.. I'm not too sure about databases but they have no problems just mounting it. It was just advice that it would probably be better in the long run to have it built straight up using 2012.
Is this true?
I don't think this is true. I believe the mount is enough. You might also run a Job after mounting it on SQL2012:
a. Check DB Integrity,
b. Rebuild+Reorganize Index,
c. Update Statistics.
Once you have run these tasks, you should be more than OK.
a. Check DB Integrity,
b. Rebuild+Reorganize Index,
c. Update Statistics.
Once you have run these tasks, you should be more than OK.
I apologize fro the delay...
Your question "Do you have any links that may help?":
My answers:
a. If you search for links suggesting a rebuild instead of a mount, I don't have any and you probably won't find any official documents suggesting you to run a rebuild since the mount is fully supported by MS.
b. If you search for links about the DB Integrity, Index, and Statistics, the SQL Books Online are the best source and you'll find almost any useful information.
Your question "Do you have any links that may help?":
My answers:
a. If you search for links suggesting a rebuild instead of a mount, I don't have any and you probably won't find any official documents suggesting you to run a rebuild since the mount is fully supported by MS.
b. If you search for links about the DB Integrity, Index, and Statistics, the SQL Books Online are the best source and you'll find almost any useful information.
Featured Post
Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| Read top line from CSV file | 14 | 60 | |
| SSIS Error on Bat File execute | 2 | 15 | |
| Sql group by orderdate and ordertotal | 3 | 12 | |
| SQL Server: Split string value in SELECT query only | 5 | 29 |
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses
Course of the Month3 days, 2 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.