asked on

How to move logings from sql 2005 to 2008 database?

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"
Now
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.

Thanks

SOLUTION

chapmandew

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

PKTG

ASKER

Thanks. But in this link it is explaining " transfer logins and passwords from SQL Server 2000 to SQL Server 2005." not 2005 to 2008. Still i can follow the same step for 2005 to 2008?

chapmandew

yes

SOLUTION