Power Architect data type IDENTITY ????

[the nigga]

Hello

I am using Power Architect to create my database models and I want ask
a question...Power Architect no have IDENTITY type to create AUTO
INCREMENT field ????

if does not have what can I use ?

thanks.

[the nigga]

I am seeing the version enterprise of power architect. That version
has option to add data types...But free version does not.
Anybody know other modeling tool ??

thanks.

[Rami Ojares]

Pen & paper.
Works in every situation.
Suppports all possible features.

- rami

[Thomas Mueller]

Hi,

Please don't use multiple "????" in your mail (and specially in the title).

Regards,
Thomas

> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To post to this group, send email to h2-da...@googlegroups.com.
> To unsubscribe from this group, send email to
> h2-database...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>

[fernando paiva]

ok Thomas...But I dont know how I do, because I am looking for any tool to make my h2 database models and I still no have found.

H2 is a good database, but no has a good tool to make a data model ER, at least not yet found.

thanks.

2011/12/9 Thomas Mueller <thomas.to...@gmail.com>

[Thomas Mueller]

Hi,

> Power Architect no have IDENTITY type to create AUTO INCREMENT field ?

If you have a question specific to Power Architect, then I suggest to ask there.

I wouldn't use graphical tool to model tables. I would use text files
instead, the easiest solution is to just use SQL scripts. If you need
a graphical representation to get a better overview about tables and
groups of tables (maybe for a presentation to others), then I would
use a graphics tool (for example OpenOffice, or InkScape).

But there are other database tools: http://h2database.com/html/links.html#tools

Regards,
Thomas

[fernando paiva]

Thomas, thanks for your attention.

I found one tool, Open ModelSphere looks like a good tool and modeling HSQLD maybe modeling H2 also. I am going to test.

here Open ModelSphere: http://www.modelsphere.com/interfaces_matrix.html

thanks a lot.

2011/12/12 Thomas Mueller <thomas.to...@gmail.com>

[ulim]

I am modelling my H2 database (23 tables at the moment) with MySQL Workbench. While that application generates MySQL-specific syntax, it is not very hard to replace that with something ANSI-like that H2 understands. Obviously, this does not work for roundtrip-style development, but it is sufficient for pure graphical modelling. MySQL Workbench is free, easy to use and has all the features I need.

Ulrich