Skip to Content

About login migrations betwwen versions

Hi masters .

I want to migrate the user logins from an ASE 12.5 to a ASE 15.7 . Can I do it with bcp or with the create insert statements from the DB Artisan or i need to use some tool ? I don´t know if the syslogins structire are the sam ? and I have no access yet to the 12.5 version, only to the 15.7

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 08, 2017 at 05:55 PM

    SAFE : Extract logins from old server with SAP tools like ddlgen or third party tool like dbartisan

    You will have to edit the SQL for passwords

    Then run the updated SQL on the new server.

    If you are interested only in syslogins port : following method is typically used for getting syslogins rows from old version to new version

    1. On old server crate a view with additional columns needed in syslogins per new version

    2. From old server bcp out -- using the view above -- in character mode

    3. New server create empty table in tempdb matching new syslogins columns

    4. New serve bcp in to tempdb table created above from the file created in #2

    5. New server turn "allow updates" on with sp_configure

    6. New server in a transaction : insert required rows (excluding names sa, probe) into master..syslogins select from tempdb..table created above

    commit transaction ( if things went as expected ) or rollback (if they did not go as expected)

    7. New server disable allow updates with sp_configure.

    NOTE: syslogins is just one part of the security. There are other related system tables which will not automatically get migrated.



    Add comment
    10|10000 characters needed characters exceeded