About login migrations betwwen versions

[former_member567823]

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

[former_member89972 · Accepted solution]

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.

HTH

Avinash

[former_member567823 · Accepted solution]

Ok, I willl try

Thank´s a lot