modelling tool

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andreas Bauer - 23 Feb 2006 17:23 GMT

Hi,

is there a good visual modelling tool for db2? I used to use fabforce
DBDesigner but it seems to produce sql statements don't work well with
db2? Is there a tool from IBM, because I would access for academic purpose.

Regards,

Andi

Reply to this Message

Serge Rielau - 23 Feb 2006 18:42 GMT

> Hi,
>
> is there a good visual modelling tool for db2? I used to use fabforce
> DBDesigner but it seems to produce sql statements don't work well with
> db2? Is there a tool from IBM, because I would access for academic purpose.

Have you taken a look at the Rational tool sets?

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

Andreas Bauer - 23 Feb 2006 21:47 GMT

Serge Rielau schrieb:

> Have you taken a look at the Rational tool sets?

There are so many :) Which one do you mean?

Reply to this Message

Serge Rielau - 23 Feb 2006 22:35 GMT

> Serge Rielau schrieb:
>
>>Have you taken a look at the Rational tool sets?
>
> There are so many :) Which one do you mean?

Touche'.

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

Andreas Bauer - 03 Mar 2006 13:52 GMT

> Touche'.

Sorry, but I can't find this.

Reply to this Message

kenfar - 26 Feb 2006 22:17 GMT

> is there a good visual modelling tool for db2? I used to use fabforce

DBDesigner but it

> seems to produce sql statements don't work well with

db2?

Good question, I second that. I'd like something that can handle MQT,
MDC flawlessly, allow CASE-style models, etc.

Hmmm, the ability to reverse engine multiple databases and diagram
their replication interfaces would be fabulous but probably too much to
wish for (I've just inherited a monster).

I used erwin in 2003, but it screwed up the identities and now that it
is owned by CA it's very aggravating to deal with support. Too bad,
used to be a nice tool. Maybe it's better since then though?

I used PowerDesigner years ago. It was ok, but not wonderful.

Embarcadero produces a good modeling tool. Can anyone recommend it for
db2?

Anything else that should be considered?

ken

Reply to this Message

m0002a@yahoo.com - 03 Mar 2006 17:09 GMT

> Embarcadero produces a good modeling tool. Can anyone recommend it for
> db2?
>
> Anything else that should be considered?
>
> ken

I use Embarcadero's ERStudio with DB2 and it seems to work fine,
including reverse engineering.

Reply to this Message

Gregor Kovač - 07 Mar 2006 09:56 GMT

> Hi,
>
[quoted text clipped - 6 lines]
>
> Andi

Hi!

We are using Sybase's PowerDesigner
(http://www.sybase.com/products/developmentintegration/powerdesigner).
Our database has over 2000 tables.

Best regards,
Kovi

Signature

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

| Gregor Kovac | Gregor.Kovac@mikropis.si |

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

| In A World Without Fences Who Needs Gates? |
| Experience Linux. |

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

Reply to this Message