Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2006
    Posts
    33

    Question Unanswered: syslogins bcp from Linux to Solaris works ?

    Hi !

    I understand that if we migrate login records in syslogins system table in the master database from Solaris to Linux, we can use bcp with character format. The login password from the Solaris platform is compatible on Linux.

    Does the same compatibility exist from Linux to Solaris as well? OR login records need to be recreated?

    Thanks in advance!

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    I've never tried this, but I suspect that if you can do it in one direction it should be possible to do it in the other as well.

    It should be pretty simple to test if you have a linux and a solaris server...

    Michael

  3. #3
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    It is not that the passwords are "compatible". For bcp out/bcp in on the same platform, use native -n format which is the fastest; for bcp out on one platform followed by bcp in on another platform, use character -c format which is a bit slower. The password is just another column but it is encrypted (and will be decrypted automatically if the bcp in -User has sso_role). I have done this across platforms many times, although I have not tried Solaris-Linux in particular.
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

  4. #4
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    There is a special trace flag(-T1650) for Solaris to Linux that peserves the password encryption in syslogins.

    I would also check with Sybase if that trace flag is valid for your EBF level. They sometimes recycle the trace flag numbers.

Posting Permissions

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