Move data from SQLServer to MySQL

Scriptcase 9 General
#1

Hi,

I need to move from table1 which is in SQLServer to table2 which is in MySQL. On the other hand, you should only pass new records, that is, you should only transfer records that do not exist in table1.

I don’t know if it’s something like this, but I don’t understand how the script will look at the two databases (mysql and sqlserver).

$sql (“INSERT INTO table1 (field_id1, field2, field3)
SELECT id_field1, field2, field3
FROM table2
WHERE field_id1 NOT IN (SELECT field_id1 FROM table1)”)
sc_lookup(ds, $sql,“conn_sqlserver”);

I’m running this code in a blank but it’s wrong.
I can’t understand how Scriptcase join two connections (mysql and sqlserver) or different servers.

I’m new to the community, thanks for the help.

#2

You cannot move data directly from SQLServer to MySQL

You need to load your data from SQLServer to local variable and then save it to your MySql DB

#3

If not asking too much (because I’m new to scriptcase). Can you give me a little example?
Thank you so much for the help.

#4

Transfering data between server has nothing to do with scriptcase, you need a PHP solution like this example

#5

I can’t do this in scriptcase on a blank for the user to run through a button on the menu?

#6

It’s ok to use it in a blank app, I mean you don’t need any special Scriptcase knowledge to do it

#7

ok… I’ll try, thanks for the help.