I had the need to compare two database schema in terms of DDLs, some definitions were not exactly the same when they were supposed to be, so in order to find out all those differences I created this script:
It will return into the dbms output the tables along with their columns and their data definition, this does not take in consideration any constraints of compare, just table names and columns.
The output of this will be something like this:
The output of this will be something like this:
So I used it to get all data from 2 database schema and compare, I hope you find this useful for yourself.
Comments