Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

migration Expand / Collapse
Author
Message
Posted Friday, May 30, 2008 4:16 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Friday, May 30, 2008 4:44 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:58 PM
Points: 1,190, Visits: 589
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 »

Add to briefcase

Permissions Expand / Collapse