# 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