Graphic tool
Posted in 2015
Jorge Valenzuela asked for a graphic tool to view a database. Art Kagel asked what he meant; Jorge wanted an ER diagram showing table relations. Art listed Datanamic Dezign for Database, AGS Server Studio, ERwin and IBM Data Studio, preferring Server Studio and Dezign. Jorge thanked him.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Topics: General Discussion
Hi, Do you know a tool to view the database in a graphic mode ? Thanks in advance. Enviado desde mi iPhone
What do you mean by "view the database in a graphic mode"? Do you want to see the table schema? An ER Diagram of the schema? Values in graphs? Or just a pretty screen to display rows and columns in a modern GUI fashion? The answer is yes to all, but without knowing what you are looking for we can't make a good recommendation. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Aug 21, 2015 at 2:00 PM, Jorge Valenzuela <jorgervt@gmail.com> wrote: > Hi, > Do you know a tool to view the database in a graphic mode ? > > Thanks in advance. > > Enviado desde mi iPhone > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113ebc3c74873a051dd6fbf2
Yes, an ER diagram of the Dbshema to view the relations between tables. Thanks. > El 21/08/2015, a las 12:07, Art Kagel <art.kagel@gmail.com> escribió: > > What do you mean by "view the database in a graphic mode"? > > Do you want to see the table schema? An ER Diagram of the schema? Values > in graphs? Or just a pretty screen to display rows and columns in a modern > GUI fashion? > > The answer is yes to all, but without knowing what you are looking for we > can't make a good recommendation. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Fri, Aug 21, 2015 at 2:00 PM, Jorge Valenzuela <jorgervt@gmail.com> > wrote: > >> Hi, >> Do you know a tool to view the database in a graphic mode ? >> >> Thanks in advance. >> >> Enviado desde mi iPhone > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113ebc3c74873a051dd6fbf2 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
OK here are a couple that I know work with Informix (most ER tools do BTW):
Datanamic's Dezign for Database (you can import your schema from a dbschema
or myschema output file and output an Informix compatible schema file. It
does not connect directly to the server for Informix.) www.datanamic.com
AGS's Server Studio - You can download this one and use its basic
functionality for free (that includes the ER Diagrammer IB). You will also
get full Enterprise functionality for a 30 day trial. Server Studio and
its companion product (Sentinel - for monitoring your server) only support
Informix. Server Studio also has all of the server management features you
need to stop using the on* commandline tools to manage your server.
www.serverstudio.com
ERWin supports Informix.
IBM Data Studio supports Informix.
Of these I like Server Studio best for its ability to automatically import
your schema and to manage your database servers. I like Dezign for
Database because you can use it to design a database graphically and
produce an SQL schema DDL script as well as reverse engineer an existing
database.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Fri, Aug 21, 2015 at 3:31 PM, Jorge Valenzuela <jorgervt@gmail.com>
wrote:
> Yes, an ER diagram of the Dbshema to view the relations between tables.
>
> Thanks.
>
> > El 21/08/2015, a las 12:07, Art Kagel <art.kagel@gmail.com> escribió:
> >
> > What do you mean by "view the database in a graphic mode"?
> >
> > Do you want to see the table schema? An ER Diagram of the schema? Values
> > in graphs? Or just a pretty screen to display rows and columns in a
> modern
> > GUI fashion?
> >
> > The answer is yes to all, but without knowing what you are looking for we
> > can't make a good recommendation.
> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.com
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on the IIUG, nor any other organization with which I
> am
> > associated either explicitly, implicitly, or by inference. Neither do
> > those opinions reflect those of other individuals affiliated with any
> > entity with which I am affiliated nor those of the entities themselves.
> >
> > On Fri, Aug 21, 2015 at 2:00 PM, Jorge Valenzuela <jorgervt@gmail.com>
> > wrote:
> >
> >> Hi,
> >> Do you know a tool to view the database in a graphic mode ?
> >>
> >> Thanks in advance.
> >>
> >> Enviado desde mi iPhone
> >
>
>
*******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > --001a113ebc3c74873a051dd6fbf2
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--047d7bdc05f2f30842051dd84c8f
Thanks.
Enviado desde mi iPhone
> El 21/08/2015, a las 13:42, Art Kagel <art.kagel@gmail.com> escribió:
>
> OK here are a couple that I know work with Informix (most ER tools do BTW):
>
> Datanamic's Dezign for Database (you can import your schema from a dbschema
> or myschema output file and output an Informix compatible schema file. It
> does not connect directly to the server for Informix.) www.datanamic.com
>
> AGS's Server Studio - You can download this one and use its basic
> functionality for free (that includes the ER Diagrammer IB). You will also
> get full Enterprise functionality for a 30 day trial. Server Studio and
> its companion product (Sentinel - for monitoring your server) only support
> Informix. Server Studio also has all of the server management features you
> need to stop using the on* commandline tools to manage your server.
> www.serverstudio.com
>
> ERWin supports Informix.
>
> IBM Data Studio supports Informix.
>
> Of these I like Server Studio best for its ability to automatically import
> your schema and to manage your database servers. I like Dezign for
> Database because you can use it to design a database graphically and
> produce an SQL schema DDL script as well as reverse engineer an existing
> database.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com
>
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Fri, Aug 21, 2015 at 3:31 PM, Jorge Valenzuela <jorgervt@gmail.com>
> wrote:
>
>> Yes, an ER diagram of the Dbshema to view the relations between tables.
>>
>> Thanks.
>>
>>> El 21/08/2015, a las 12:07, Art Kagel <art.kagel@gmail.com> escribió:
>>>
>>> What do you mean by "view the database in a graphic mode"?
>>>
>>> Do you want to see the table schema? An ER Diagram of the schema? Values
>>> in graphs? Or just a pretty screen to display rows and columns in a
>> modern
>>> GUI fashion?
>>>
>>> The answer is yes to all, but without knowing what you are looking for we
>>> can't make a good recommendation.
>>>
>>> Art
>>>
>>> Art S. Kagel, President and Principal Consultant
>>> ASK Database Management
>>> www.askdbmgt.com
>>>
>>> Blog: http://informix-myview.blogspot.com/
>>>
>>> Disclaimer: Please keep in mind that my own opinions are my own opinions
>>> and do not reflect on the IIUG, nor any other organization with which I
>> am
>>> associated either explicitly, implicitly, or by inference. Neither do
>>> those opinions reflect those of other individuals affiliated with any
>>> entity with which I am affiliated nor those of the entities themselves.
>>>
>>> On Fri, Aug 21, 2015 at 2:00 PM, Jorge Valenzuela <jorgervt@gmail.com>
>>> wrote:
>>>
>>>> Hi,
>>>> Do you know a tool to view the database in a graphic mode ?
>>>>
>>>> Thanks in advance.
>>>>
>>>> Enviado desde mi iPhone
>
*******************************************************************************
>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>> --001a113ebc3c74873a051dd6fbf2
>
*******************************************************************************
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> --047d7bdc05f2f30842051dd84c8f
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>