syncloginsfromASE12.5.4to

[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

 

为桐柏等地区用户提供了全套网页设计制作服务，及桐柏网站建设行业解决方案。主营业务为网站建设、做网站、桐柏网站设计，以传统方式定制建设网站，并提供域名空间备案等一条龙服务，秉承以专业、用心的态度为用户提供真诚的服务。我们深信只要达到每一位用户的要求，就会得到认可，从而选择与我们长期合作。这样，我们也可以走得更远！

分享题目：syncloginsfromASE12.5.4to
文章网址：http://mswzjz.cn/article/jpdocp.html