Improve Generate Data Model Performance


(Bart Elia) #21

If you have not spent anytime in the command line tools section of the help, spend 15 minutes to review it… We continue to add a bunch of scripting abilities every release for routine pain points - especially migration oriented


(Jose C Gomez) split this topic #22

2 posts were split to a new topic: How to use Command Line for Data Model Regeneration


(Jose C Gomez) #23

@aidacra was nice enough to put together a pretty awesome how-to regarding command line data model regen. Thanks Nathan!


(Simon Hall) #24

I believe it is touched on in the System Admin manual as well. It also mentions about adding tables to the schema, which is something I have not even considered, I’ve always worked within the boundaries of what’s there.


(Bart Elia) #25

We need that functionality for Partners to add tables as a part of their efforts. Even our own CSF teams needs to add new tables so the need is there though usually geared to higher level integration’s.


(Simon Hall) #26

How do upgrades cope with such tables?


(Bart Elia) #27

Migration does not touch custom tables.
The inclusion of the custom tables into the data model is optional. The data model regen walks thru all tables in a db schema. There is a schema to include - Ice, Erp - and an exclude for tables -

<!–Comma delimited list of additional schemas to include. By default only standard schemas are included.–>
<SchemasToInclude/>
<!–Comma delimited list of tables to exclude from the data model.–> <TablesToExclude>
Ice.SysSequence,Ice.DBMigrationLog
</TablesToExclude>