In the Agency software business
in the UK, there is a seasonal pattern. As the Christmas period
approaches, NHS nurses do as much overtime as possible to build up
their pay packets. As a consequence, Agency nurses and
Agencies (can) get a quiet period. This usually means that
it's that time of year when server moves are scheduled. With Ava
often helping out in these moves or migrations, it's a busy time
for us. With SQL 2008 being a year old, the more nervous and
cautious are migration from SQL 2000, SQL 2005 to SQL 2008.
Here are some links to articles I've found on the web to help this
process:
An overview of migrating SQL 2000 to 2008 from dell - in clear
English.
http://www.dell.com/downloads/global/solutions/public/white_papers/SQL_2000_SQL_2008_Migration_Guide.pdf
And the Microsoft offerings:
How to transfer logins and passwords between instances of SQL
Server
http://support.microsoft.com/kb/246133
How to transfer the logins and the passwords between instances of
SQL Server 2005 and SQL Server 2008
http://support.microsoft.com/kb/918992
How to redirect Ava Pa to connect with the new server: