How to SELECT from MySQL and then INSERT result in MSSQL

General
1

Please suggest a method where I get data using MySQL

SELECT column 1, column 2, ..... column n FROM MySQL_database

then insert the results using MSSQL node

INSERT INTO MSSQL_database
(column 1, column 2, ..... column n)
Values
(value a1, value a2,..... value an),
(value b1, value b2,..... value bn),
....................
(value x1, value x2,..... value xn)

2

Which part don't you know how to do? What have you achieved so far?

3

I haven't tried to run it with database
image

I used split node then join node.

flows.json (643.1 KB)
but check if there is a better way.

I was trying to do this via function node alone.

4

node-red-contrib-mssql-plus has a bulk insert feature and it has a built-in demo named "Bulk demo" (use CTRL-I to view and import examples)

5

Yes, I was just reading it. (link)

image
image697Ă—106 4.6 KB

But I don't know why example is missing in my node red. :man_shrugging:
image

6

coping form github link.

7

I tried 3 ways of doing it. Sharing flow if anyone might need it some day.
image

flows.json (25.5 KB)

1 Like
8

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.