in reply to dbi cookbook for database administration

I have some scripts and modules that I'd be willing to contribute, but I need time to re-write them from scratch (I originally wrote them for a client, so they own it now). I've wanted to do that for a while, so this is good motivation.

What I would have:

I may have a couple of other goodies laying around, if you're willing to wait a few weeks.

Replies are listed 'Best First'.
Re: Re: dbi cookbook for database administration
by mpeppler (Vicar) on Nov 07, 2002 at 17:04 UTC
    A fairly plain "schema reporter"
    Are you aware of the dbschema.pl script that I first wrote many years ago, and that is currently maintained by David Owen (see www.midsomer.org). It uses the Sybase::DBlib module, but it generates a nearly perfect schema from the database (including users, logins, devices, etc).

    Other reference sites for Sybase DBA information (which includes monitoring) include Todd Boss' site (www.bossconsulting.com and Ed Barlow's www.edbarlow.com (although I haven't really looked at his perl code...)

    Michael

[reply]
Re: Re: dbi cookbook for database administration
by busunsl (Vicar) on Nov 08, 2002 at 07:18 UTC
    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!

[reply]

In Section Meditations