The current schema comparison mechanism only represents a simple text comparison between two DB schemas, and also its performance isn't efficient enough.
It's necessary to improve this function to provide an efficient and functional schema comparison scheme to user, which could leads them to more effectively understand the difference between DBs.
The enhanced Schema Comparison Function contains:
1. Display table info comparison between DBs (in General/Detailed View)
2. Display table schema comparison between DBs
3. Provide table schema alter script (bidirectional: source->target, target->source)
4. Display entire DB schema comparison
5. Provide entire DB schema alter script (bidirectional: source->target, target->source)
Attached figures represent an example of two xe DB schemas comparison by using the updated mechanism.