Database Schema Version Control

The main goal of this diploma thesis is to design and implement an application that would be capable of searching for differences between two database schemas. There are many uses for such tool, but there is one that is the most common. Two database schemas are created with the same SQL script, so they are equal at the beginning. A user can later add or modify database objects in one of the schemas, so the schemas may not be equal anymore. The implemented tool can find the differences between the schemas and present the results to the user in various formats (diff tree in GUI, XML, and text). The most valuable form of output is undoubtedly an SQL script. The purpose of the SQL script is the synchronization of the two schemas. The user can execute such script in a database containing the second schema, and the second schema will be modified according to the first schema