Where you are allowed to view cross platform databases in one
application. Are they useful?

Grace
www.nrgglobal.com

Grace wrote:
[color=blue]
> Where you are allowed to view cross platform databases in one
> application. Are they useful?
>
> Grace
> www.nrgglobal.com[/color]

What is a cross-platform database? What do you mean by this?

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Daniel Morgan wrote:
[color=blue]
> What is a cross-platform database? What do you mean by this?[/color]

Though I'm not *him* I guess he means distributed databases.

Frank

Hello Grace,

You can try ERWIN by CA and ER-Studio by embarcadero. Both products
support multiple database (like Oracle, DB2, SQL-Server, etc).

ERWIN has more options, but more expensive as well. ER-Studio is a good
tool. Both tools can convert local Entity-Relationship diagrams (models) to
physical schemas for required database type and can reverse-engineer
physical schema to logical ERD as well.

Regards,

Support
DBA Infopower LLC
http:// www.dbainfopower.com


"Grace" <gliu@nrgglobal.com> wrote in message
news:ca14daea.0402041631.3aa5a7d5@posting.google.c om...[color=blue]
> Where you are allowed to view cross platform databases in one
> application. Are they useful?
>
> Grace
> www.nrgglobal.com[/color]

gliu@nrgglobal.com (Grace) wrote in message news:<ca14daea.0402041631.3aa5a7d5@posting.google. com>...[color=blue]
> Where you are allowed to view cross platform databases in one
> application. Are they useful?
>
> Grace
> www.nrgglobal.com[/color]

Are you looking for something like Visio that allows you to model
non-existent databases, generate .sql statements, or otherwise assist
in the creation of databases? (Visio may not be the best tool for
distributed database modelling, but it's the first thing that comes to
mind.)

Alternatively, are you looking for a tool that allows you to link in
heterogenous and/or distributed database tables and treat them as one,
homogenous data store. For example, an end user app could join a DB2
Customer table and an Ingres Customers table--each with differing data
types and column names--and query them.

Netrista Khatam
Technical Services Manager
OpenLink Software Web: http://www.openlinksw.com
Product Weblogs:
Virtuoso: http://www.openlinksw.com/weblogs/virtuoso
UDA: http://www.openlinksw.com/weblogs/uda
Universal Data Access & Virtual Database Technology Providers

MetaMatrix specifically addresses cross platfom data modeling & integrated
views for read/write, dist. transactons.Not just to databases but many
different sources. It tletsyouu model thhem, crateintegrated viewsthem
deploy them as a virtual database or XML documents as a webservice.

The product also comes with an open indusstry standard repository. The
modeler includes impact analysis & dynamic dependancy diagrrams.

Regards,
David Penney (MetaMatrix)
http://www.metamatrix.com

"Grace" <gliu@nrgglobal.com> wrote in message
news:ca14daea.0402041631.3aa5a7d5@posting.google.c om...[color=blue]
> Where you are allowed to view cross platform databases in one
> application. Are they useful?
>
> Grace
> www.nrgglobal.com[/color]

hello grace,

Maybe our data modeling tool is something for you: DeZign for Databases
More information can be found at http://www.datanamic.com

kind regards
rick


gliu@nrgglobal.com (Grace) wrote in message news:<ca14daea.0402041631.3aa5a7d5@posting.google. com>...[color=blue]
> Where you are allowed to view cross platform databases in one
> application. Are they useful?
>
> Grace
> www.nrgglobal.com[/color]

You can download a trial of ER/Studio from here. Its a great tool fro
modelling / reverse engineering databases.
http://www.embarcadero.com/products/erstudio/index.html

"DBA Infopower Support" <support@dbainfopower.com> writes:

[color=blue]
>Hello Grace,[/color]
[color=blue]
> You can try ERWIN by CA and ER-Studio by embarcadero. Both products
>support multiple database (like Oracle, DB2, SQL-Server, etc).[/color]
[color=blue]
> ERWIN has more options, but more expensive as well. ER-Studio is a good
>tool. Both tools can convert local Entity-Relationship diagrams (models) to
>physical schemas for required database type and can reverse-engineer
>physical schema to logical ERD as well.[/color]

When I looked at embarcadero er-studio, it did not support relationships
between 3 or more entities. Since I consider this a mandatory requirement,
I have not considered it a usable tool. Have they upgraded this aspect of
the tool?

As an aside, I also don't like the way Embarcadero markets their products.
if you buy one, they send you a CD with the entire suite. When I installed
one of their products, I, unknowingly, installed a tool that was not part of
the subset of the suite my employer had purchased, and when I did the
process to request a key to use the part that was purchased for more than
30 days, it also generated a request for the tool that wasn't purchased,
which led to one of their rabid dog marketing folks doing cold calls to me
to try to convince me to buy it. When the person would not take no for an
answer, I eventually said something like, "Look, this product is worthless,
and I'm not interested." This led to the person phoning my boss to say I
was being uncooperative and tactless or some such. So I personally won't
have anything to do with Embarcardero or their tools if I have any say in
the matter, but this is a different issue from whether one of their products
might meet your needs.

Cheers,

Joseph

Hi Grace,

please feel free to try our CASE Studio 2 - database design tool. It
allows you to reverse engineer already existing databases (more than
20) and generate very detailed SQL scripts or HTML/RTF reports.

http://www.casestudio.com

Regards,

Kind regards

Vaclav Frolik
--------------------------------------------------
CHARONWARE s.r.o. - data modeling tools
-------------------------------------------------