I'm tasked with 'rebuilding' a database server, because the old one is dying. To reduce potential for the new server f**king up, we had decided to rebuild the server as similar as possible to the old one, hence, SQL Server 2005 Enterprise on top of Windows Server 2003.
Now, the original dev/maintainer of the old server has gone the way of the dodo (as in, he's left the company quite some time ago, and nowhere to be found now). So, we had to do the migration in-whole.
To make matters worse, the old server is a hodge-podge of: Databases, a mix of user credentials (SQL Server authentication and Windows authentication), a crowd of Linked Servers, and a gaggle of SQL Server Agent Jobs.
So, how do I approach this monumental task? In my mind, I had the following half-baked plan:
- Copy the databases using the Copy Database Wizard
- Copy the users using Script > CREATE To
- Re-create all Linked Servers
- Copy the Jobs using Script > CREATE To
For every step above, I might have to do it one-by-fricking-one :(
Is there an easier (as in, less tedious) way to do the migration?