How do I migrate InfluxDb to SQL Server?

Lavakumar 1 Reputation point
2021-01-25T08:55:18.267+00:00

We have been trying to migrate InfluxDb to SQL Server. Since InfluxDb is time series database, the time will be the primary key. But in SQL Server we are using GUID as the primary key. Is there any way to migrate large data sets from Influx to SQL Server using column mapping? We cannot insert manually as there is huge data in influx. Programmatic migration really doesn't help because it impacts the DB performance and takes a lot of time.

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
532 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 13,976 Reputation points Microsoft Vendor
    2021-01-26T06:51:09.777+00:00

    Hi Lkcode-0387,

    migrate large data sets from Influx to SQL Server using column mapping.

    You may try to use SQL Server Import and Export Wizard to import data. After you select the existing tables and views to copy or review the query that you provided, if you click Edit mappings, the SQL Server Import and Export Wizard shows the Column Mappings dialog box.
    Please refer to Start the SQL Server Import and Export Wizard and Import and Export Data with the SQL Server Import and Export Wizard which might help.
    Since I am not familiar with influxdb and cannot help you well, you can open thread in the InfluxCommunity which could get more help.

    Best Regards,
    Amelia

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.