Good morning.

I need to upgrade to SQL Server 2008 from SQL Server 2000.

I've downloaded and will run the upgrade assistant to identify my prereqs.

Any words of wisdom for the upgrade? Any known pitfalls, etc.?

Thank you for your help.

Sal

Following is the broad checklist :

1. Take full backup of databases before migrating
2. User security should match with new database
3. Test of connectivity from all different sources
4. Check for following connectivity:
   1. Remote users are able to connect as earlier (with updated client)
   2. batch jobs are running fine
   3. imports and exports jobs are running fine

__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.

Thank you very much for your quick reply.

I'm assuming that all logon IDs will convert and they will not need to be recreated. is this correct?

Basically you run a script at the sql2000 machine. Then run the output on the sql2005/sql2008 machine.

If the accounts are windows integrated they will just need to be created. But if they are sql accounts, they need to preserve their 'SQL' SID in order to work with the database, since its the sid, not the account name that connects them to a database.

Furthermore you need the hashed password so your users can continue use their passwords.

If your application are bought, the vendor should be able to assist in such a migration, that is if the application has support for SQL 2008.

Also check the following link:
http://support.microsoft.com/kb/246133

__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.

Thank you!