Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add Command-Line Execution Support #16

Open
whellcome opened this issue Dec 21, 2024 · 0 comments
Open

Add Command-Line Execution Support #16

whellcome opened this issue Dec 21, 2024 · 0 comments
Labels
enhancement New feature or request proposal development proposal

Comments

@whellcome
Copy link
Owner


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.

@whellcome whellcome added enhancement New feature or request proposal development proposal labels Dec 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request proposal development proposal
Projects
None yet
Development

No branches or pull requests

1 participant