Skip to content

Support scripting collation on database objects and add option to ignore collation #57

@zacateras

Description

@zacateras

Add support in the CLI tool to handle scripting of collation definitions on database objects. Users should be able to choose whether collation clauses are included in the generated scripts.

  • Add an option to the sqlct.config.json configuration file (e.g., "ignoreCollation": true) to allow users to skip scripting collation when enabled.
  • No command-line switch should be implemented as part of this task. Only the config file option should be supported for enabling/disabling collation scripting.
  • By default, collation should be preserved to match the source database unless the ignore option is specified in the configuration.
  • Update documentation, sample config, and any schema to reflect this new option.
  • Cover relevant scenarios in unit/integration tests.

Acceptance Criteria:

  • Collation clauses are scripted by default in supported DDL outputs.
  • Suppressing collation scripting via the config file works correctly for all supported object types.
  • Documentation and config file help reflect this new option.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions