Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: MaXyM 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
-
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
-
Thanx. Indeed it seems so called post-processing is the only way.