User Answers

what ODBC driver you are using ? Crystal's or InterSystems? Try using a later/est compatible InterSystems ODBC driver.

Common SQL tools like WinSQL can do that, since Cache is a supported database in WinSQL

Ensemble SQL Adaptors are pretty good in syncing. Can that code be used here ?