How many of us have worked with upgrading a database schema from version ‘y’ to version ‘x’ for an application? Most of us who have worked on that, would have feared ‘are my upgrade scripts correct?’ ‘do they match the schema if I create a fresh schema for x version?’
We are working on such a tool, that you could run against 2 schemas, and see the differences. The tool would take a source schema as a reference point, and compare the objects against the target schema. You would have options to do a deep comparisions like data compare in addition to regular schema comparision, where only table schema is compared.
Tool would allow you to work with MS SQL Server, Oracle and MS Access.
Rolex
I found your entry interesting do I’ve added a Trackback to it on my weblog