Open
Description
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
).
- Specifying the database 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.