I am brand new to Data Point, so this might be a simple question but I'm struggling to figure it out.
I want to read data via a query from mysql and insert data into SQL Server.
Insert into SQLServerDB.Table (Field1,field2)
set field1 = mysql.field1,
field2 = mysql.field2
where id = mysql.id;
delete from SQLServerdb.table
where id in (select id from mysqldb.table);
I think that shows what I'm wanting to do.
Can someone point me in the right direction?