I have a need to copy data between MySQL and SQLite databases. I’m wondering what would be the best approach. I was thinking about using SC macro “sc_change"Connection”. Read record from database1 then switch connection and save this same record into database2. Not sure how well this would work and how efficient this would be. Of course on the way I might need some data manipulation (filtering, inserting some data in the fields, etc.). Because of the data manipulation I cannot copy those records blindly, records which need to be copied must go through some procedure (which is not important here for the question). I also need to do the TIMESTAMP() field comparison. The Synchronization will be done initially one way only but late on it will be bi-directional.
I wonder if anybody has done something like that or if there is any other better solution.