When you migrate from ase 15.0.2 to 15.7 you will notice that the syslogins table structure has been changed. Due to this change we need to add some info to the user list when migration between 15.0.2 to 15.7
First, “bcp OUT” syslogins from your ASE v15.0.2 dataserver:
bcp master..syslogins out master.v15.syslogins.bcp -c -t"|" -r"\n" -Usa -SASE_LN |
The syslogins tables has changed between the versions so we need to add |-1| to each line.
2 fields have been added that don’t affect the performance or security of the system.
sed -i " s/$/|-1| /" master.v15.syslogins.bcp |
Next we load the table into the new ASE 15.7 master database.
sp_configure 'allow updates',1go bcp master..syslogins in master.v15.syslogins.bcp -c -t"|" -r"\n" -b 1 -Usa -SASE_LN sp_configure 'allow updates',0go |
All logins are migrated with minimal effort and no passwords need to be changed. As an extra bonus you don’t need to change the user sid in the database you migrate from 15.0 to 15.7