数据库比对工具

数据库比对工具是一款绿色小巧的数据库对比软件

功能：

该软件作用是将两个数据库(sqlserver)进行表结构比对，软件界面简洁，操作简单方便。

数据库对比方法：

altersessionsetsort_area_size=1024000000;setserveroutputon;declarestate1varchar2(250);state2varchar2(250);typecur_sorisrefcursor;cur_1cur_sor;cur_2cur_sor;num1number;num2number;num3number;begin--altersessionsetsort_area_size=1024000000;deletefromw_tab_cols;deletefromw_tab_only;deletefromw_tab_lob;commit;forrecin(selectdistincttable_namefromuser_tab_cols@s_linkwheretable_namein(selecttable_namefromuser_tab_cols@s_linkwheredata_typelike'%LOB%'ordata_typelike'%LONG%'))loopinsertintow_tab_lobvalues('s_link',rec.table_name);endloop;forrecin(selectdistincttable_namefromuser_tab_cols@d_linkwheretable_namein(selecttable_namefromuser_tab_cols@d_linkwheredata_typelike'%LOB%'ordata_typelike'%LONG%'))loopinsertintow_tab_lobvalues('d_link',rec.table_name);endloop;forrecin(selecttable_name,column_name,data_type,data_lengthfromuser_tab_cols@s_linkwheretable_namenotin(selecttable_namefromuser_tab_cols@s_linkwheredata_typelike'%LOB%'ordata_typelike'%LONG%'))loopinsertintow_tab_colsvalues('s_link',rec.table_name,rec.column_name,rec.data_type,rec.data_length);endloop;forrecin(selecttable_name,column_name,data_type,data_lengthfromuser_tab_cols@d_linkwheretable_namenotin(selecttable_namefromuser_tab_cols@d_linkwheredata_typelike'%LOB%'ordata_typelike'%LONG%'))loopinsertintow_tab_colsvalues('d_link',rec.table_name,rec.column_name,rec.data_type,rec.data_length);endloop;forrecin(selecttable_namefromw_tab_colswhereside='s_link'andtable_namenotin(selecttable_namefromw_tab_colswhereside='d_link'))loopinsertintow_tab_onlyvalues(rec.table_name,'s_link');endloop;forrecin(selecttable_namefromw_tab_colswhereside='d_link'andtable_namenotin(selecttable_namefromw_tab_colswhereside='s_link'))loopinsertintow_tab_onlyvalues(rec.table_name,'d_link');endloop;--forrecin(selectdistincttable_namefromw_tab_colswheretable_namenotin(selecttable_namefromw_tab_only))loopnum1:=0;num2:=0;num3:=0;selectcount(*)intonum1fromw_tab_colswheretable_name=rec.table_nameandside='s_link';selectcount(*)intonum2fromw_tab_colswheretable_name=rec.table_nameandside='d_link';selectcount(*)intonum3from(selecttable_name,column_name,data_type,data_lengthfromw_tab_colswhereside='s_link'andtable_name=rec.table_nameintersectselecttable_name,column_name,data_type,data_lengthfromw_tab_colswhereside='d_link'andtable_name=rec.table_name);ifnum1=num2andnum2=num3andnum3=num1theninsertintow_tab_onlyvalues(rec.table_name,'both');endif;endloop;forrecin(selectdistincttable_namefromw_tab_colswhereside='s_link'andtable_namenotin(selecttable_namefromw_tab_only))loopinsertintow_tab_onlyvalues(rec.table_name,'struct_diff');endloop;commit;forrecin(selecttable_namefromw_tab_onlywhereside='both'andtable_namenotlike'BIN$%')loopnum1:=0;num2:=0;state1:='selectcount(*)from(select*from'||rec.table_name||'@s_link'||'minus'||'select*from'||rec.table_name||'@d_link)';executeimmediatestate1intonum1;state2:='selectcount(*)from(select*from'||rec.table_name||'@d_link'||'minus'||'select*from'||rec.table_name||'@s_link)';executeimmediatestate2intonum2;ifnum10ornum20thenupdatew_tab_onlysetside='data_diff'wheretable_name=rec.table_name;endif;endloop;commit;end;/

Tags:数据库.