????4.?汾???
?????汾????????°汾????????汾??????????????????????????磺
????[sql] view plaincopy
????call MOBILECLINIC_CHECK_VERSION('MC-1.0.0-0003');
????update DB_VERSION d set d.DATABASE_VERSION = 'MC-1.0.0-0002' ?? d.MIN_SERVER_VERSION = 'MC-1.0.0-0002' ??d.UPDATE_DESC = '??????' ??d.UPDATE_TIME = SYSDATE() ;
????--????????μ???????--
????alter table TEMP drop column XXX;
????5.?汾????
?????汾??????????????£?????????????????汾??????????????????汾??

????6.?????汾????????
?????????汾??????????????£?
???????????? = ????????
?????????????Baseline
????Contraction script?????????????????creation???????ddl????initialization???????dml????cleanup?????????
????Expansionscript????Change Set???????????????С???
????7.?????汾????????????
?????????汾???????????????£??????????????????????

????8.????????Change Set??????
????Change Set????????·?????ж??壺
??????????CS_Baseline_YYYYMMDD_PatchNo.sql??????CS_Tanggula2_20121223_01.sql
???????裺????????????汾У?飻DDL/DML???£????????С?????????汾????
????9.????????Roll Back??????
????Roll Back????????·?????ж??壺
??????????RB_Baseline_YYYYMMDD_PatchNo.sql??????RB_Tanggula2_20121223_01.sql
???????裺???????????汾У?顢DDL/DML????????????С?????????汾???
????10.?????汾?????????ù???
????????SVN?????ù???????У??????????ο????2??????????й????

????????????????
??????????????????汾???????????????????????????????????????????????????????????????????????????????????????????????????????????????????Liquibase??http://www.liquibase.org?????????????????ChangeSet??Roll Back??Liquibase????????????SQL Change Set??????????o??????????????????£?

 

????????Liquibase??????maven?????????????й????????????????

????????Liquibase?????????????????????????г????
?????壯С??
???????ù????????????汾????????????????????????????????汾????????з??????????ù???????????????????????????????????Щ?·??????????ο???