sync logins from ASE 12.5.4 to ASE 15.5

[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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26735168/viewspace-751406/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26735168/viewspace-751406/