I would like to export demographics from MS-SQL to MySql.
How do we do that in robotask.
Thanks for a great application.
MS-SQL to MySql
MS-SQL to MySql
What is the problem?
I think that you have to make "Dataset Loop" by MS SQL table
and append record into MySQL table within the loop.
Algorithm approx is such:
DataSet loop // like this - Select * from my table where ... order by ...
SQL Query // insert into mytable (field1, field2,... ) values (.....)
end loop
"Dataset loop" and "SQL Query" connects to the database you specified in connection string. It may be different databases.
But remember that RoboTask uses only ADO connections. There are ADO abd ODBC drivers for MySQL database. You can find it in Internet. (e.g. here http://dev.mysql.com/downloads/connector/)
I think that you have to make "Dataset Loop" by MS SQL table
and append record into MySQL table within the loop.
Algorithm approx is such:
DataSet loop // like this - Select * from my table where ... order by ...
SQL Query // insert into mytable (field1, field2,... ) values (.....)
end loop
"Dataset loop" and "SQL Query" connects to the database you specified in connection string. It may be different databases.
But remember that RoboTask uses only ADO connections. There are ADO abd ODBC drivers for MySQL database. You can find it in Internet. (e.g. here http://dev.mysql.com/downloads/connector/)