SQL 2005 to 2012 Migration Question
Posted on 2014-01-17
I have done a number of migrations in the past but mostly same versions, I am looking into a project that will require I migrate 16 database servers from single instance (Physical Server) 2005 into a single virtual server running named instances and using SQL 2012.
I need to migrate the db's including the system db's which hold the log in's and permissions. Is there a best practice or step by step procedure I can follow to accomplish this?
And before anyone is concerned about iOPS this is a SSD Array all DB certified SSDs :)