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
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
Microsoft SQL ServerMicrosoft SQL Server 2008Microsoft SQL Server 2005
Last Comment
Raja Jegan R
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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?
yes
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks . Pls explain me my other questions(2-4) also. Thanks again.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.