comment on

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!

In reply to Re: Re: dbi cookbook for database administration by busunsl
in thread dbi cookbook for database administration by busunsl

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


good chemistry is complicated, and a little bit messy -LW
	PerlMonks