Results 1 to 4 of 4

Thread: db transfer

  1. 10-08-1999, 07:24 AM #1
    Dave King Guest

    db transfer


    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
    Reply With Quote Reply With Quote
  2. 10-08-1999, 08:41 AM #2
    Craig Guest

    db transfer (reply)

    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
    Reply With Quote Reply With Quote
  3. 10-11-1999, 06:45 AM #3
    rosta Guest

    db transfer (reply)

    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.
    Reply With Quote Reply With Quote
  4. 10-11-1999, 06:57 AM #4
    Craig Guest

    db transfer (reply)

    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules