I want to migrate a specific database from SQL Server 2000 to SQL Server 2008 R2, I've done some reading and this is the steps I plan to take:
(1) Run the SQL Server 2008 Upgrade Advisor to see if there are any potential problems when I move this database to 2008 R2.
(2) Backup the database and restore the .bak file in SQL Server 2008
(3) Run DBCC CHECKDB
My first question is:
(1) Is my plan the correct way to to a migration from 2000 to 2008 R2?
(2) How do I bring over all of the logins and permissions over to 2008 R2?
Thank you in advance!