Post reply

Username Validation

  • February 22, 2008 at 4:03 am

    #154144

    Hi,

    We are going to migrate all database and applications from one server to another server.

    We are planning to migrate all the databases including Master database.

    After migration we want to cross verify the usernames between the two servers.

    We want to know how to perform this activity without manually cross checking each and every username in each server for each database.

    Please share your thoughts in this regard.

    Thanks,

    Karthikraj.L

  • February 22, 2008 at 4:11 am

    #781029

    Hi

    How are you going to migrate your users. I think you will have to script all your logins and users and create them in the server that you are moving to.

    "Keep Trying"

  • February 22, 2008 at 4:16 am

    #781030

    Sure...I'll do that.But I want to know is there any specific scripts like that stuff to validate the users after migration.

    Regards,

    Karthikraj.L

  • February 26, 2008 at 11:23 pm

    #782362

    Hi

    by validate do you mean checking for existence of the users and whether they are connected to the appropriate database. Or you want to compare whether the same users exist in your oldserver and new server.

    Since you are scripting the logins/uses you may not need to do this.

    "Keep Trying"

  • February 27, 2008 at 11:39 am

    #782755

    All you need to do is move the user databases, script the jobs and run the the other server, move the logins. This hould do for you. all the logins since they have the same SIDs you need not do anything more than this.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 5 posts - 1 through 4 (of 4 total)

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