Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    1

    Unanswered: Merging Sybase Users

    Does anyone know of an easy way to merge Sybase users from 2 dataservers into one? Syslogins is different on both servers.

  2. #2
    Join Date
    Aug 2007
    Posts
    1

    How to consolidate sybase logins from two servers

    Do the following

    1. BCP out the logins from server 1 using following command

    BCP master..syslogins out logins_server1.tct -Uxxx -Pxxx -SXXX -c


    2. BCP out the logins from server 2 using following command

    BCP master..syslogins out logins_server2.tct -Uxxx -Pxxx -SXXX -c

    3. Open Excel and pat the contents on both files in the excel worksheet

    4. Change the suid to be sequential numbers startin with a number higher
    than the suid of the highest sybase system login

    5. save the worksheet as a text file called logins_server3. txt

    6 BCP in the logins from server 2 using following command

    BCP master..syslogins in logins_server3.tct -Uxxx -Pxxx -SXXX -c

    Note: make sure you have allow updates to systems tables set to on (1)
    or the bcp in will not work.

Posting Permissions

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