We are planning to upgrade our SQL server from 2005 to 2012, and we also have to move our SQL Server data to a different datacenter.
I was thinking I could just set up an identical SQL server 2005 in the new datacenter, and start log shipping from the current one to the new one, then set up a new instance of SQL Server 2012. When all the log shipping is caught up and we are ready to make the switch, I would simply turn off log shipping, detach the databases from SQL 2005, and attach them to SQL 2012.
I was wondering if anyone knew of any complications I might have with upgrading using that method. I know it will take awhile since I need to move about 1.8 tb of data and the network from the old datacenter to the new one is kind of slow.