# 1.读取sqlservers数据库内容到我们的数据库：新增（全局/增量），修改 ### 1.1 orcale链接工具 30  ### 1.2 测试运行晋辉写的单元测试 30 ### 1.3 查找sql server 和 orcale 数据变动后mysql 更新，增加 60 ### 1.4 下载工具Kettle开源的ETL工具 30   可以同步mysql 和sql server ,orcale数据   ### 1.5 给mysql /sql server/orcale 建立测试表 30 orcale： --create table member(memberId number(11) PRIMARY key, --nickName VARCHAR2(50), --imageUrl VARCHAR2(100), --openid VARCHAR2(50), --status NUMBER(2)); --create SEQUENCE member_sequence INCREMENT by 1 start with 1 NOMAXVALUE NOCYCLE NOCACHE; --create trigger mem_trig before --insert on member for each row when (new.memberId is null) --BEGIN -- select MEMBER_SEQUENCE.NEXTVAL into:new.memberId from dual; --end; -- --insert into member(nickName,imageUrl,openid,status) --select '王五','https://qitniu','sslekedl',0 from dual union all --select '李白','https://qitniu','sslekedl',0 from dual --COMMIT; SELECT * FROM MEMBER; sql server: /*create table member(memberId int identity(1,1) PRIMARY key not null, nickName VARCHAR(50), imageUrl VARCHAR(100), openid VARCHAR(50), status int);*/ /*insert into member(nickName,imageUrl,openid,status) values ('小样','https://kdk','ss16s23s',0), ('老虎','https://kdk','ss1d623s',0);*/ select * from member mysql: /*create table member(memberId int auto_increment PRIMARY key not null, nickName VARCHAR(50), imageUrl VARCHAR(100), openid VARCHAR(50), `status` int);*/ INSERT INTO member(nickName,imageUrl,openid,STATUS) VALUES ('smem','https://kdk','ss16s23s',0), ('litao','https://kdk','ss1d623s',0); # 2. 开会 120 # 3. 熟悉erp数据字典 30