Re: Re: dbi cookbook for database administration

[busunsl]

Script to invert $SYBASE/interfaces so you can see if you have something double-mapped.

Cool, would go into the miscellaneous section.

Scripts to compare tables, columns, indexes, views in two databases, then either report them or generate "candidate" SQL to resolve differences.

That would be great.

A fairly plain "schema reporter".

If plain means it is only covering the basic structure, I'd prefer dbschema.pl as Michael suggests.
But I'd like to see it nevertheless.

if you're willing to wait a few weeks

I just started having ideas and some pieces of code. I'll be glad to get some more pieces in a few weeks, in the meantime I can put together what I have so far.

Many thanks!