Printable View
I recently transferred a db from our production machine to a test machine. After the transfer was complete I realized that all copied logins were copied with blank passwords. Is this default behavior? Can I set the transfer to include passwords?
Dave King
No, you cannot copy passwords.
------------
Dave King at 10/8/99 8:24:25 AM
I recently transferred a db from our production machine to a test machine. After the transfer was complete I realized that all copied logins were copied with blank passwords. Is this default behavior? Can I set the transfer to include passwords?
Dave King
Yes, you can!
Copy the syslogins table from original server in master db into
temp table.
Then transfer this table to new server.
Last step is updating of the new server.master.syslogins.password
column to values from the transfered temp table.
To clarify, with Transfer Manger, there is no way to transfer passwords.
------------
rosta at 10/11/99 7:45:46 AM
Yes, you can!
Copy the syslogins table from original server in master db into
temp table.
Then transfer this table to new server.
Last step is updating of the new server.master.syslogins.password
column to values from the transfered temp table.