We are migrating SQL Server 2005 database to SQL Server 2008(Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1) in New windows 2008 Machine. I restore the database into 2008 and ran the "Alter database Roamex SET COMPATIBILITY_LEVEL = 100"
1. what is the best method to move logings from 2005 to 2008. Can i use SSIS - Transfer Logins Task or any other method is easy and efficient. Please advise me .
2. First i need to move logings and then i need to move database or first need to restore database then logins.
3. And also anything else i need consider for Database migration from 2005 to 2008.
4. How to verify restored database is working fine or not.