A
Anonymous
Guest
Ok, here is my situation. I have a database program that uses MySQL on the users local computer (for offline work), but the online version (situated on a server elsewhere) maybe MySQL, Access, Oracle, or something else. When the user makes changes to the db, it stores the SQL query in a log file.
Here's the question, if the user wants to then import the changes (data) in to the online db, can I just load the SQL query in using something like adodb and all is well?? I am try to work with 2 different databases see, and am not sure if this is possible. From what I can see from adodb it takes care of all the communication with the difference databases, you just need to feed it the SQL queries and it does the rest.... I am I too naive
Thanks,
Graham.
Here's the question, if the user wants to then import the changes (data) in to the online db, can I just load the SQL query in using something like adodb and all is well?? I am try to work with 2 different databases see, and am not sure if this is possible. From what I can see from adodb it takes care of all the communication with the difference databases, you just need to feed it the SQL queries and it does the rest.... I am I too naive
Thanks,
Graham.