sql server database upgrade procedure
Posted on 2014-03-04
I have a program that connects to a SQL server database.
The server is currently server2003 - sql server standard 2003 v8.00.760 (SP3) 32bit
I need to upgrade the software and the software want the backend database upgraded to 64bit.
I have a second server running srv 2008 and sql svrr 2008, and I have a license for sql svr 2012 ready to go.
What would be the best procedure to move the database over to the new server and upgrade it to 64bit?