migration

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » migration

migration

Rate Topic

Display Mode

Topic Options

Author

Message

crazy4learn

Posted Friday, May 30, 2008 4:16 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, July 22, 2008 7:21 AM
Points: 12, Visits: 296

hi all,

1) if we are migrate sql server 2000 db to sql 2005 , so wat abt the jobs and passwords??
means this objects are migrated to 2005 ?? or we have to do some manually work like create new logins and passwords?? i ran that sp_help_revlogin screept but wt abt passwords?
2) wt abt sqllogins and windows login during migration?

Post #509407

MohammedU

Posted Friday, May 30, 2008 4:44 PM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 09, 2013 1:53 PM
Points: 1,190, Visits: 499

When you use sp_rev_login script to copy the logins it will generate the script of logins with passwords...means what ever the password at your source server the destination server will have the same password...

For jobs, operators and alerts...
You can script them in EM and run in 2005...

MohammedU
Microsoft SQL Server MVP

Post #509412

« Prev Topic | Next Topic »

Permissions