NorthStarDA
IS-IT--Management
Hello,
I have been long searching for a way to synchronize data between a FMP database and MySQL database. I have a MySQL database setup for online reporting, but all of our internal databases are FMP. Is there a way to use the Execute SQL script step to update records in the MySQL database, or insert new if they dont exist via primary key?
I have been long searching for a way to synchronize data between a FMP database and MySQL database. I have a MySQL database setup for online reporting, but all of our internal databases are FMP. Is there a way to use the Execute SQL script step to update records in the MySQL database, or insert new if they dont exist via primary key?