February 22, 2008 at 4:03 am
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
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
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
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
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