Migrate data from SQL Server to Influxdb

Hello @rudoce,
You can use the sql.from() function in a task:

But task are better suited towards continuous transformation work rather than a bulk migration.
Same with many Telegraf input plugins (they’re used to continuously read and write data)

To perform a bulk migration from SQL, you might be better off writing your data to a file or a series of files depending on how much data you have. Then I’d use the telegraf file plugin:

Assuming you can write your data into any of the following formats:

Please let me know if that answers your question.

1 Like