Re: Database Tooling

[Mark Murphy <jmarkmurphy@xxxxxxxxx>]

I use SQuirreL client as the databases I work with are older and don't have
any referential integrity built in, and many aren't properly normalized
anyway. I find it works better than Run SQL Scripts for general SQL Client
use. Maybe I am just used to those keystrokes. For the things it can't do,
I use other tools, but it is rare that I need something else.

ERwin does indeed work with DB2, or did at one time. I have seen demo's
with it accessing a DB2 database on the AS400, yes, that long ago. But it
is ex$$$pen$ive. The base version costs $300 a month, or $3000 per year.
The workgroup version costs $400 per month or $4000 per year. I still think
these prices are per seat, there is just some extra useful functionality.
On the plus side, there is a free trial on their web site.
https://erwin.com/products/erwin-data-modeler/

On Fri, Apr 5, 2019 at 5:30 PM Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

> I'm trying to build a list of the database tools in use by our community.
> Preferably ones that actually understand that IBM i exists (even if it
> calls it AS/400 or whatever).
>
> I am familiar with IBM's Data Studio, and with dBeaver.
>
> What other tools are folks using and what are their major features. For
> example Data Studio supports a form of visual builder for SQL as does
> dBeaver (in the professional version). Similarly they both support some
> form of entity/relationship mapping.
>
> What's in your toolkit?
>
>
> Jon Paris
>
> www.partner400.com
> www.SystemiDeveloper.com
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com