Skip to content

Add Command-Line Execution Support #16

Open
@whellcome

Description

@whellcome

Description
Enable the MS Access to SQL Export Tool to be executed via the command line. This feature is essential for integrating the tool into automated ETL (Extract, Transform, Load) pipelines and batch jobs, making it suitable for enterprise use.

Proposed Features

  • Add a CLI (Command-Line Interface) for:
    • Specifying the database path (--db-path).
    • Selecting specific tables for export (--tables).
    • Enabling or disabling the inclusion of foreign key constraints (--include-fk).
    • Outputting the SQL script to a specified file path (--output-path).
  • Include options for logging (--log-path) and verbosity levels (--verbose).

Use Cases

  • Automating the regular backup of MS Access databases in SQL format.
  • Incorporating the tool into enterprise ETL processes.
  • Allowing scheduled exports for data migration tasks.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requestproposaldevelopment proposal

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions