Book a Demo

Author Topic: Scripted Automation of database RE  (Read 3053 times)

MaXyM

  • EA User
  • **
  • Posts: 120
  • Karma: +8/-0
    • View Profile
Scripted Automation of database RE
« on: September 21, 2018, 10:11:48 pm »
hello
Does EA provides ability to automate RE of database (Show difference... option)? In particular I need to deselect some objects from the list to be imported.

The background for this need is the bug in a query EA sends to database which is being REd. The query doesn't exclude all system triggers (only relationship ones). So every time I do RE for updating existing model, I have manually unselected huge amount of triggers.
Or maybe some one knows how can I fix the SQL query EA is using? The issue has been acknowledged under id: 18038571 in April 2018. I even sent corrected SQL query.

with regards

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13495
  • Karma: +572/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Scripted Automation of database RE
« Reply #1 on: September 21, 2018, 10:42:32 pm »
No, I don't think so.
You can't execute it via the API, and you can't influence it with templates or anything like that.

What we did was do some post-processing after importing the database.
I remember that there were a number of things we needed to fix after importing a DB2 database from a mainframe (over ODBC).
The program we wrote parsed the DDL and did some corrections and additions based on the info found in there.

Geert

MaXyM

  • EA User
  • **
  • Posts: 120
  • Karma: +8/-0
    • View Profile
Re: Scripted Automation of database RE
« Reply #2 on: September 22, 2018, 12:47:27 am »
Thanx. Indeed it seems so called post-processing is the only way.