Solved

SQL05 on 2K3 OS to SQL 2012 on OS Server 2012

Posted on 2015-02-12
3
91 Views
Last Modified: 2015-02-12
Guys
I have request to build a new SQL server; Windows Server 2012 (any edition) and install SQL 2012.
They currently have a SQL 2005 service running on a Windows Server 2003 box.
I am drafting in a brand new highly beefed up server, loads of local resource to more than cater for there needs.

However, are there any 'Goychas' I need to highlight to these guys in terms of OS and SQL version differences?
Once the new server is presented they will go through the necessaries to move the DB instances and data across from 2k3/SQL05 over to the new 2k12/SQL12, and just want to make sure they don't come back saying there are unchangeable incompatibility issues.
All advice welcome and in advance thank you for your help.
0
Comment
Question by:CTCRM
3 Comments
 
LVL 46

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 250 total points
ID: 40605410
You just need to run the SQL Server Upgrade Advisor that you'll find in the SQL Server 2012 media. Run it against the MSSQL 2005 database and will give you a report of known issues.
0
 
LVL 68

Accepted Solution

by:
Qlemo earned 250 total points
ID: 40605433
If the database is just transferred, it stays at 2005 comparability level, so no change there.

User related stuff like security settings and logins need to be reapplied.
0
 
LVL 2

Author Closing Comment

by:CTCRM
ID: 40605499
Thanks Guys, it seems that I have nothing to worry about regarding compatibility.
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now