MEGA documented in SQL tables and querys

[cerrejon]

Hi, I can document how MEGA tables and SQL querys, or any reference document to do. regards

[cerrejon]

right that's what I need Thank you

[hsoegaard]

Excuse me for saying so, but you are not expressing yourself very clearly.

But from what I can understand from the thread, you would like to document tables of a database associated with an application that you have created in Hopex.

In order to do so, you would need the Database Builder module, which manages the conceptual, logical and physical level of a database.

[cerrejon]

Hello, If it refers to data models modeling

[jhorber]

If I understand and are definitely using HOPEX with SQL Storage (SQL server, Oracle)

1) You want to ist of tables used

2) Maybe you also want to access (consultation, update) the tables from an external application

Let us go further

1) There is no document that list these tables.

As said before in this thread, we do not provide documentation regarding our implementation in SQL databases

If you want to have a good idea of the data model, it is wised to list and browse the Metaclasses using HOPEX common tools (query, explorer, metamodel diagrams..)

2) Consultation and update can be performed using the standard end user interface or the API script

Regarding consultation and update from an external application

• Read access is not recommended (at customer's risk)
• Update access is prohibited: we do not allow than an external application updates the persistence model in SQL.

See also http://community.mega.com/t5/custom/page/page-id/mega-kb-solution?sid=501D0000000KvxWIAS

[cerrejon]

What I want to do is register tables in databases MEGA, example link: http://www.google.com.co/imgres?imgurl=http://www.iesroqueamagro.org/pluginfile.php/7240/mod_resourc...

[ki6i]

If you mean modelling data models? you can do that with Data Model, Entity objects and etc. if you want exactly SQL database modelling you can use the Database and Table objects in mega

[jhorber]

Sorry but this is still not clear

What do you mean by "register the database schema of applications registered in MEGA"?

[cerrejon]

Hello, I have an application called DOAG with your database, what I want is to registar tables database of that application. Cheers,

[jhorber]

Hello cerrejon

What do you mean by "register the database schema of applications registered in MEGA"?

Can you provide more details on what you intend to get?

[ki6i]

What I would do if I was you is to use the MEGA API to export the needed data of the Application and the diagrams and store them to different database.