Custom Exported Database Model

• Exported Database Model is a set of JSON files exported from a database.

• It contains -- definitions of database objects (schemas, tables, views, columns) -- code artifacts (stored procedures, functions, triggers)

• Definition of database objects should match objects defined by code (CREATE TABLE/VIEW...), but it is not always true. Definitions of database objects exported from database may be out-of-date.

Views processing options

• On MS SQL Server, the views metadata may not be up-to-date Read more
• If the views metadata are not up-to-date, also the views column names in exported database model might be obsolete
• From this reason, option readDbModelViewColumns is added to analyzerOptions section of Input Definition JSON
• if the option readDbModelViewColumns is true, the view columns are read at the beginning and processed like regular tables
• if the option readDbModelViewColumns is false (default and recommended)
  • Before processing
    • the views are created with only empty column lists.
    • external column "Id"s from db model are saved
  • During processing, the columns are added from view definitions (CREATE VIEW AS SELECT ...)
  • After processing, external "Id"s are restored from database model