PowerDesigner 16.5 UpdateModelFromDatabase function in VBscript

[Former Member]

Hi,

I am trying to write a script that compares two physical data models. I already have a PDM on my repository and I want to compare it to a reverse-engineered PDM which is the DB production version of the same model. The idea is to update the repository version when the production version changes. I was wondering if there was a function in VBScript that was doing the same thing (or almost) as the "UpdateModelFromDatabase" option on the PowerDesigner GUI. I also noticed the "Compare" function in VBScript, which could potentially help me. Unfortunately, there is not a lot of documentation around and it is hard to know how to include the differents parameters to correctly use that function.

I am seeking the attention of someone who ever tried to code something like I'm describing. Thanks a lot in advance for your precious help.

Antoine

[GeorgeMcGeachie · Accepted solution]

Sorry, I'm with you now.

On the Database menu, you'll find the option "Update Model from Database", which will connect to the database and update the model with selected changes. Use this in combination with model versions in the repository (along with perhaps Branches and/or configurations). Alternatively, carry on reverse-engineering into new models, then merge those models into your master PDM.

[Former Member · Accepted solution]

Thanks a lot for you help! I'll be trying this. I just noticed that I have your book on my desk! I have to say that it helped me a lot to go through all the possible options in PowerDesigner. Do you know if there is a "Update Model from Database""-like function in VBScript? In the best world, I would like to automate the update process without having to go through the PD GUI to update my models manually each time.

Regards,

Antoine