Is it possible to generate a diff by comparing a target database with a source database model defined in an XML file?
A use case:
A database schema model is defined and maintained in the development projects source code repository in an XML format
Developers can change schema by changing XML files. Source code repository can show a diff between two versions.
During the deployment, of a new version there is an easy and quick way to evolve the target schema to the required version. Developers do not have to maintain each DDL in a separate script to handle a scenario in which a process running script may have been aborted before completion of the script.