Link to home
Create AccountLog in
Avatar of IDMA
IDMAFlag for United States of America

asked on

How Do I Update from SQL 2005 to SQL 2012?

Hey everyone.

Well, the title says it all.  Any articles, tips, etc that you have would be appreciated.

Thank you
Avatar of didnthaveaname
didnthaveaname

Unless your underlying OS is Windows Server 2008, you're looking at having to migrate your database to a completely new server.  Take a look at my post: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_28121746.html#a39148501.  All of that information is going to be relevant as you're looking at a migration scenario, not a strict upgrade.  Hope it helps!
Avatar of Giladn
you mean UPGRADE .. :)

all is written here, quoting is unneccesary
http://msdn.microsoft.com/en-us/library/bb677622.aspx

post back if you have any questions..

G
Avatar of IDMA

ASKER

Correct..  Sorry.  Yes, this is going to be a brand new server.  Either 2008 R2 or 2012
great, so you have a new server and you want to MIGRATE data from the old server to a new server including users, DBs and settings? then it is a MIGRATION , not and upgrade or update.
an I correct?
Avatar of IDMA

ASKER

Giladn,

That's right.  I stand corrected, again.
what is the porpose of this sql server? how many  DBs? is it being used with a 3rd party application?
SOLUTION
Avatar of Giladn
Giladn
Flag of Israel image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of IDMA

ASKER

It will be holding our McAfee ePO, which we are upgrading, too, and our ticketing database.  There might be plans for it to host our accounting software database (Sage-Timberline), too, but that's not an absolute yet.
Avatar of IDMA

ASKER

Also, does this apply to SQL 2012, too?
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
P.S

haven't done this myself but this should apply to sql 2012 as well , SSIS (used to copy DBs) package should do the work.
I would really encourage you to look into the guts of the migration options...  They all have their strengths and weaknesses.
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account