Hello,
I need a step by step approach on how to migrate sql server 2005 on a windows server 2003 machine to sql server 2012 on a windows 2012 machine.
I need to upgrade the user databases and I need every thing from the original instance - users/passwords, resolving orphaned users, updating default databases, updating system properties, migrating jobs, SQL Agent Operators, recreating DB Mail Profiles, change data capture functionality, restoring partitioning information and other specific database options that were once enabled.
(Unfortunately, I have not been approved to use a methodology that creates an instance of the same version of sql server 2005 on a windows 2008 machine,
restore the system databases and user databases and then use the migration wizard on the 2008 machine to upgrade to sql server 2012 on the windows 2008 machine and then restore these databases to sql server 2012 on the windows 2012 server. Irina Tudose's blog)
Any help would be appreciated.
I need a step by step approach on how to migrate sql server 2005 on a windows server 2003 machine to sql server 2012 on a windows 2012 machine.
I need to upgrade the user databases and I need every thing from the original instance - users/passwords, resolving orphaned users, updating default databases, updating system properties, migrating jobs, SQL Agent Operators, recreating DB Mail Profiles, change data capture functionality, restoring partitioning information and other specific database options that were once enabled.
(Unfortunately, I have not been approved to use a methodology that creates an instance of the same version of sql server 2005 on a windows 2008 machine,
restore the system databases and user databases and then use the migration wizard on the 2008 machine to upgrade to sql server 2012 on the windows 2008 machine and then restore these databases to sql server 2012 on the windows 2012 server. Irina Tudose's blog)
Any help would be appreciated.
