sync logins from ASE 12.5.4 to

[1] on ASE 12.5.4
select * into tempdb..loginaa16 from master..logins
go

then,use DBAartisan migrate tempdb..loginaa16 to HKCORP(80.17)'s tempdb

[2]on ASE 15.5
insert into master..syslogins and update sa and probe's password.

sp_configure 'allow updates',1
go

delete from master..syslogins where name not in ('sa','probe')
go

insert into master..syslogins(suid,status,accdate,totcpu,totio,spacelimit,timelimit,resultlimit,dbname,name,password,language,pwdate,audflags,fullname,srvname,logincount,procid,lastlogindate,crdate,locksuid,lockreason,lockdate)
select suid,status,accdate,totcpu,totio,spacelimit,timelimit,resultlimit,dbname,name,password,language,pwdate,audflags,fullname,srvname,logincount,procid,null,null,null,null,null from tempdb..loginaa16 a where not exists (select 1 from master..syslogins b where a.name=b.name)

go


update master..syslogins set password=(select password from tempdb..loginaa16 b where b.name='probe') where name='probe'
go

update master..syslogins set password=(select password from tempdb..loginaa16 b where b.name='sa') where name='sa'
go

drop table tempdb..loginaa16
go

sp_configure 'allow updates',0

go