|
From: David D. Jr. <dav...@gm...> - 2007-09-13 14:27:50
|
On 9/12/07, Robert Manning <rob...@gm...> wrote: > On 9/12/07, David Durham, Jr. <dav...@gm...> wrote: > > Does Squirrel SQL have a way to compare SQL catalogs for differences > > in schemas, tables, procedures, constraints, etc.? > > > > I'm looking for results along the lines: > > > > catalog a is missing table x, which is present in catalog c > > At the moment, I'm working on a plugin that will allow you to diff two > tables and get a listing of columns that are different and how they > differ. No support yet for schema/catalog comparison yet. That is > probably a few months away. That's great. I'm happy with Squirrel as an SQL workbench type of tool. I've actually written some catalog comparison type of tools in the past using JDBC metadata. Another thing that's useful, besides meta-data comparisons, is a comparison of the actual data. In the case of a table, a row-count is sometimes useful pseudo-equivalency test. It also gives you an idea of how expensive a record values comparison would be. I'd be willing to donate time to a db comparison plugin for Squirrel, but I'm not yet familiar with the source code for Squirrel. Thanks, Dave |
