Ability to copy data between datasources

[mageddo]

Description

Once connected to a database using CSV2JDBC, e.g. H2, I want to be able to use copy data across different databases:

1. Be able to import data to the current database creating and insert data from a select from other database datasource
2. Be able to export data from current database using a select and exporting to another database creating and inserting data there

Proposed command syntax:

Importing Data from an external datasource to current table

CSV2J COPY <table> 
FROM (<statement>) 
WITH DATASOURCE <datasourceName> [CREATE_TABLE]

Exporting Data from current datasource to another

CSV2J COPY (<statement>)  
TO <table>
WITH DATASOURCE <datasourceName>  [CREATE_TABLE]

Reference

• Related use cases
  • 1
  • 2
  • 3