how do I visually see relationships in a DB?

[korsuas]

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

 

[GuptaSteve]

Please be more specific - what DB are you running ?

 

[GuptaSteve]

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.

 

[korsuas]

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

 

[GuptaSteve]

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.

 

[GuptaSteve]

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