On our todo list, for this new SQL destination, is to add a ‘Batch Move’ option. This option will handle a csv text data file and will insert the data content to a database.
In version v2019.8.17.0 a first relase of this ‘Batch Move’ option was added to SQL as Source and Destination. It is the first release so many features still need to be added to this option.
At the moment:
SQL as Source: Batch Move will get the data from the selected database and will output this to csv file. We automatically recognize the data source format but also will add an options later for a manual setup.
SQL as Destination: Batch Move will take the data from the source (csv) file and will insert this data into the Database.
You can choose between SQLite, Microsoft SQL, PostgreSQL, MySQL and MariaDB as Database. Don’t forget to set the Table Name in the Batch Move tab.
Feedback would be much appreciated.