Is it possible to save data models in the database tables directly?

[former_member554397]

Is it possible to save data models in the database tables directly?

Publish / retrieve data from the server (not in the repository)

[GeorgeMcGeachie]

Please clarify what you mean, Alex.

If you want to save a data model in the PowerDesigner Repository using SQL, I'd say "don't even think about it".

[former_member554397]

No. I am interested that the models are not stored in proprietary xml-files (pdm, eam, rqm, fem, bpm), but in the database tables.
In 3NF tables, such as systwm tables for MS Sharepoint content or other systems that serialize their data into database tables.
This would be useful for Upload, Update, Extract data by SQL-commands (Insert, Update, Select)

[GeorgeMcGeachie]

Sorry Alex, but I still don't know what you expect PowerDesigner to do for you. It looks like you want to be able to take some of the PDM and put it somewhere. Could you describe exactly what you're asking, please? I know PowerDesigner very well, but I have no idea what systwm tables are, or what they contain.

[GeorgeMcGeachie]

It sounds like you want to do one or more of the following:

• reverse-engineer from a database into a new model
• update a data model from a database
• create a database from a data model
• apply data model changes to a database

The first option is available on the File menu, the rest are available on the Database menu. They're all covered in the Help system - look for "Generating and Reverse-Engineering Databases".

[former_member554397]

I don't want to use the repository. I want to publish dataset to the server table