February 27, 2006 at 4:44 pm
Hi, I need to move some databases from one server to another new server.
I know that exists some differents ways to do this, using DTS or running sp_help_revlogin and sp_hexadecimal.
If I'm not wrong it moves all users running on source server to target server, my question is if exists a way to only move users and passwords from each database to move and not all of users in my source server.
Thanks for any help.
February 28, 2006 at 5:53 am
if you can take the database offline, then detach it, copy the .mdf (and .ldf if you want to keep the log) to the new server's data folder, and then attach.
February 28, 2006 at 6:29 am
If I understand correctly, you want to transfer users of a database with corresponding passwords. Passwords are stored with the login. The Transfer Logins task in DTS can be used and it lets you select which database(s) on the source to transfer.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply