INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

how do I visually see relationships in a DB?

how do I visually see relationships in a DB?

(OP)
I would like to have a software to see/print relationships just like Access or MSSQL... does anyone know smtg like that?

Thank you,
Adrian Korsuas

RE: how do I visually see relationships in a DB?

Please be more specific - what DB are you running ?

RE: how do I visually see relationships in a DB?

One option is to use the Gupta tool TOM - Team Object Manager.  You must have Imported your database schema by using the import wizard under 'Import Data Model' menu item and then 'Database' menu item under the 'Data Models' section , which exists under the 'Project' you must create for this excersise. Once the schema has been imported from whatever source, you have many options to view and/or compare it in a pictorial format. The options you choose when importing the schema, dictate how they are displayed afterwards i.e. use the 'Referential Integrity' option if SqlBase. You should be using TOM as a repository for your Gupta code already ( hope you dont use MS Visual Source Safe ) , in which case you can see 'Data Models' as one of the Project's sections, and take it from there.

RE: how do I visually see relationships in a DB?

(OP)
Hi there, Steve,

Thank you for your answer. I am using Gupta SQL Windows version 3.0, from 2002. I use SQLBase Sever version 8.0

I have located TOM, but when I connect co the db it says:
"The database name you specified does not contain the Team Object Manager repository.
Please specify the repository database name, and try again."

Well, it doesn't even check for the username/password.

I did not find 'Import Data Model' menu item, or the  'Data Models' section...:(

I am not using MS Visual Source:)

Ah, I'm kind of in a fog...

Please tell me more if you can.

Thank you,
Regards,
Adrian Korsuas




RE: how do I visually see relationships in a DB?

One option is to use the Gupta tool TOM - Team Object Manager.  You must have Imported your database schema by using the import wizard under 'Import Data Model' menu item and then 'Database' menu item under the 'Data Models' section , which exists under the 'Project' you must create for this excersise. Once the schema has been imported from whatever source, you have many options to view and/or compare it in a pictorial format. The options you choose when importing the schema, dictate how they are displayed afterwards i.e. use the 'Referential Integrity' option if SqlBase. You should be using TOM as a repository for your Gupta code already ( hope you dont use MS Visual Source Safe ) , in which case you can see 'Data Models' as one of the Project's sections, and take it from there.  

RE: how do I visually see relationships in a DB?

Please tell me you are using 32bit TeamDeveloper v3.0 and not 16bit SqlWindows v3 !
It sounds like you dont have TOM installed correctly. Once installed it is a great tool for many different jobs. TOM uses its own SqlBase database as a repository to store all your source code,schema  etc.   This seperate TOM database must be up and running and TOM correctly installed before you can connect to it.  You can use SqlTalk to test if you can connect to your TOM database .  To install TOM and its database correctly, you must have some knowledege of the tool, and so try re-installing your Centura software - but only the TOM part, The TOM database can be installed either locally or on a mapped server (pref. server for backup),and you must configure Sql.ini to include this TOM database as follows:


;
; SQLBase Communication Protocol Gateways ( Database MYTOM = Local TeamObjectManager Repository)
;

[dbnt1sv]
servername=Thorin(Server where TOM DB is installed) ,sqlapipe
cache=2000
partitions=0
secureapi=0
dbdir=D:\CENTURA(Path where TOM DB is installed) ,
DBNAME=MYTOM(TOM DB name),,SQLAPIPE

[dbnt1sv.dll]
comdll=sqlapipe

[dbnt1sv.gui]
MAINWIN=NORM,555,424,1045,776
STATWIN=NORM,241,143,482,286
DBWIN=NORM,241,0,482,143
PROCWIN=NORM,0,143,241,286
SYSWIN=NORM,0,0,241,143
DISPLEVEL=4
TIMESTAMPS=1


Once installed, TOM will be well useful....
Come back if no luck
Cheers
Steve Leighton

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close