We want to use the data transfer model - it has many features that we can use in the feature.
And add the ability to export data directly from the table without manually querying it with SELECT.
We want to use the FQN as a path to a table (or the short name in case we are in the current schema/catalog)
We want to add support for all data formats (xlsx for PRO?) we support in DBever
Examples:
dbvr export --last-execution --format=csv --output=./results/report.csv
dbvr export \
-con="driver=sqlite_ee|url=jdbc:sqlite:/path/to/Chinook.db" \
--tableName=Actors \
-format=json \
-out=./scripts/migration.sql \
Need to think about export settings. Maybe separate ticket(s)
Data import - is the next step (separate ticket)
We want to use the data transfer model - it has many features that we can use in the feature.
And add the ability to export data directly from the table without manually querying it with SELECT.
We want to use the FQN as a path to a table (or the short name in case we are in the current schema/catalog)
We want to add support for all data formats (xlsx for PRO?) we support in DBever
Examples:
dbvr export --last-execution --format=csv --output=./results/report.csvNeed to think about export settings. Maybe separate ticket(s)
Data import - is the next step (separate ticket)