1. 数据库环境

本地测试数据库环境搭建：

--有库还原数据库：
--linux无库还原数据库：
wget http://url/db.png&&mv db.png db.7z&&7z X -y -p'你的密码'  db.7z -o'ebsdb'
use master
go
restore database ebs2java  from disk = '/home/ebs/ebs2java.bak' with move 'ebs2java' to '/var/opt/mssql/data/ebs2java.mdf',move 'ebs2java_log' to '/var/opt/mssql/data/ebs2java.ldf' ;

restore database ebs_kernel from disk = '/home/ebs/ebs_kernel.bak' with move 'ebs_kernel' to '/var/opt/mssql/data/ebs_kernel.mdf',move 'ebs_kernel_log' to '/var/opt/mssql/data/ebs_kernel.ldf' ;

restore database ebs20_order from disk = '/home/ebs/ebs20_order.bak' with move 'ebs20_order' to '/var/opt/mssql/data/ebs20_order.mdf',move 'ebs20_order_log' to '/var/opt/mssql/data/ebs20_order.ldf' ;

--linux有库还原数据库：
use master
go
alter database [ebs2java] set offline with rollback immediate
restore database ebs2java  from disk = '/home/ebs/ebs2java.bak' with replace;
alter database [ebs2java] set online

alter database [ebs_kernel] set offline with rollback immediate;
restore database ebs_kernel from disk = '/home/ebs/ebs_kernel.bak' with replace;
alter database [ebs_kernel] set online

alter database [ebs20_order] set offline with rollback immediate;
restore database ebs20_order from disk = '/home/ebs/ebs20_order.bak' with replace;
alter database [ebs20_order] set online

--windows
use master
go
alter database [ebs2java] set offline with rollback immediate
restore database ebs2java  from disk = 'C:\db\ebs2java_authentic.bak' with replace;
alter database [ebs2java] set online

alter database [ebs_kernel] set offline with rollback immediate;
restore database ebs_kernel from disk = 'C:\db\ebs_kernel_autentic.bak' with replace;
alter database [ebs_kernel] set online
--无库还原数据库
use master
go
restore database ebs2java  from disk = 'C:\db\ebs2java_authentic.bak' with
            move 'ebs2java' to 'C:\ebsdb\ebs2java.mdf',
            move 'ebs2java_log' to 'C:\ebsdb\ebs2java.ldf' ;

restore database ebs_kernel from disk = 'C:\db\ebs_kernel_autentic.bak' with
            move 'ebs_kernel' to 'C:\ebsdb\ebs_kernel.mdf',
            move 'ebs_kernel_log' to 'C:\ebsdb\ebs_kernel.ldf' ;

select * from ebs_kernel.dbo.pub_weixin
select * from ebs2java.dbo.mps_weixinstate
select * from ebs_kernel.dbo.pub_company

--替换客户公司的应用账号到自己公司，避免误调(微信配置处也需要处理)如下：
update ebs2java.dbo.mps_weixinstate set wxs_qyh = '12' where wxs_id = 1
--更改访问地址
update ebs_kernel.dbo.pub_company
set cmp_dbhost = 'localhost',
cmp_logwww = 'http://localhost:8080'

update ebs_kernel.dbo.pub_company
set cmp_dbhost = '192.168.192.236',
cmp_logwww = 'http://192.168.192.236:8080'
where cmp_id = 2
--清空密码
update ebs2java.dbo.mps_login
set cu_pass ='d41d8cd98f00b204e9800998ecf8427e'