DBDiff for Oracle 是用来比较两个Oracle schema异同的一个小工具。可以比较权限,表结构,视图结构,索引,约束,序列,表数据,视图数据,触发器,包,包体,函数,过程,类型,类型体等等。
具体功能看官方介绍:http://www.dkgas.com/oradbdiff.htm
另外,OraFAQ对这个工具也有介绍:http://orafaq.com/tools/dkg/dbdiff.htm
官方网站上可以下到demo版(http://www.dkgas.com/oradbdiff.exe)
比较时的主要界面:
比较的结果如下:
< DATABASE 1: NING@NING
> DATABASE 2: TEST@NING
Differences found in system privileges
PRIVILEGE ADMIN OPTION _
< CREATE TABLE NO
< UNLIMITED TABLESPACE NO
Differences found in role privileges
GRANTED ROLE ADMIN OPTION DEFAULT ROLE OS GRANTED _
> CONNECT NO YES NO
< DBA NO YES NO
Differences found in object privileges
PRIVILEGE TABLE NAME OWNER GRANTEE GRANTOR GRANTABLE _
< READ DIR_TEST SYS NING SYS YES
< WRITE DIR_TEST SYS NING SYS YES
26 tables were found in NING@NING
0 tables were found in TEST@NING
The following tables DO NOT exist in TEST@NING
BIN$e1qUSe8vQQiU9lFFYnMJ7w==$0
BIN$8bLjznPlRoioTrMiKI/YUg==$0
BIN$gBo6cUZnTMKady7Prxmr3A==$0
BIN$5laeMO9NSdK2mvDDF/QM6w==$0
BIN$2emTg5hhR8iAWHwHO9yJHA==$0
The following tables were not processed in NING@NING
NOTE: The Demo version will only process the first 5 tables in alphabetical order,
if more than 5 tables exist in your database, they will appear in this section.
COLS255
COLS254
COLS256
COLS511
COLS260
COLS257
TESTDIM
ITL
TMP
BIN$Q3KgLnUgStGMfbZILCY0Gw==$0
BIN$RPq3nKBoS96SY/u1Ff6bow==$0
BIN$H7FDdRrBS0uw7kc6DWU6WQ==$0
BIN$PFZrpEZCQ2iC4VMsQPVhCg==$0
BIN$SG7Qv49SR/a8mkoCWAYuWg==$0
BIN$V9drUKNiQQOGslcIFFjntg==$0
T2
BIN$iJermRGLTXiy2YfNbqJVxg==$0
T1
BIN$W5dSTLm3Q4iKDDg5e/gVUw==$0
BIN$s2Mmqz2PQw+BGYMknTZBwQ==$0
TEST
0 views were found in NING@NING
0 views were found in TEST@NING
2 triggers were found in NING@NING
0 triggers were found in TEST@NING
The following triggers DO NOT exist in TEST@NING
BIN$ZzTBPKmbRgKmRYkbCAoFJQ==$0
TR_T1
0 views were found in NING@NING
0 views were found in TEST@NING
0 functions were found in NING@NING
0 functions were found in TEST@NING
0 packages were found in NING@NING
0 packages were found in TEST@NING
0 packages body were found in NING@NING
0 packages body were found in TEST@NING
2 stored procedures were found in NING@NING
0 stored procedures were found in TEST@NING
The following stored procedures DO NOT exist in TEST@NING
TEST_CASE
TEST_COLS
0 types were found in NING@NING
0 types were found in TEST@NING
0 types body were found in NING@NING
0 types body were found in TEST@NING
--- End of DBDiff for Oracle --- Elapsed Time: 00:00:01 ---
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/193161/viewspace-50304/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/193161/viewspace-50304/