Re: Database Tooling

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