IDMA
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
Well, the title says it all. Any articles, tips, etc that you have would be appreciated.
Thank you
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-exchang e.com/Micr osoft/Deve lopment/MS -SQL-Serve r/SQL_Serv er_2008/Q_ 28121746.h tml#a39148 501. All of that information is going to be relevant as you're looking at a migration scenario, not a strict upgrade. Hope it helps!
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
all is written here, quoting is unneccesary
http://msdn.microsoft.com/en-us/library/bb677622.aspx
post back if you have any questions..
G
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?
an I correct?
ASKER
Giladn,
That's right. I stand corrected, again.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
Also, does this apply to SQL 2012, too?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.