Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2007
    Posts
    167

    Unanswered: How do I syncronize logins (suid) between PROD and DEV?

    I just installed a new development Sybase ASE server and want to sync the logins / suid from our prduction server to our development server.

    I think the best way to do this is to bcp out the logins from syslogins (PROD server) and bcp in to the DEV server syslogins. Is this the best way?

    Are there any other system tables that we have copy as well? Please keep in mind, we only have 15 accounts.

    Is there a manual way of doing this, I'd love to learn how this as well.

    Thank you.

  2. #2
    Join Date
    Mar 2007
    Posts
    72
    Hi,
    The best way is to do a bcp out/in of the syslogins table. this is the easiest way that I can think of.

    S Rao

  3. #3
    Join Date
    Mar 2007
    Posts
    167

    Do I need to sync other system tables?

    Thank you for your help and advice.

    Do I need to sysc other system tables? For example...

    Sync. the following system tables...

    - syslogins
    - sysloginroles
    - syssrvroles (which currently seems to be the same across all servers)
    - sysattributes (which currently seems to be the same accross all servers with both the object_type of 'UR' and 'PS').

    What are your thoughts?

    Thank you.

  4. #4
    Join Date
    Sep 2005
    Posts
    9
    Quote Originally Posted by ftmjr
    Thank you for your help and advice.

    Do I need to sysc other system tables? For example...

    Sync. the following system tables...

    - syslogins
    - sysloginroles
    - syssrvroles (which currently seems to be the same across all servers)
    - sysattributes (which currently seems to be the same accross all servers with both the object_type of 'UR' and 'PS').

    What are your thoughts?

    Thank you.
    No, you don't need to sync other system tables other than syslogins.

Posting Permissions

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