Feature Request: Add CLI Flag to Exclude Specific Tables from DBML Generation

Feature Suggestions
1

I am currently using the system-versioned (temporal) table feature in Azure SQL, which automatically manages historical data for versioned tables. While these tables are crucial for internal data tracking, they are not necessary in schema documentation, such as DBML files, as they primarily function behind the scenes.

I would like to request a new CLI flag for the dbdocs db2dbml tool to exclude specific tables from the DBML generation process. This flag would allow users to tailor the output by omitting certain tables, which might be unnecessary in the generated schema documentation. This could include:

  • Tables based on explicit names (e.g., passing a list of table names to exclude).
  • Tables matching a naming convention (e.g., tables with a specific prefix or suffix).
  • Tables with specific properties (e.g., system-versioned or temporal tables in SQL Server).

This feature would significantly improve the readability and usability of generated DBML for databases leveraging advanced features like system-versioned tables, keeping the focus on the business logic tables rather than behind-the-scenes functionality.

2

This is a promising idea. We have added this to our backlog and will consider it in the future.

Thank you for making this feature suggestion.

1 Like