Post reply

migration

  • May 30, 2008 at 4:16 pm

    #154400

    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?

  • May 30, 2008 at 4:44 pm

    #822588

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply