Replies

oh.. yes .. Auditing and temporal are two different use cases

is this for the the purpose of auditing datachange ? then why not using the built in auditing function by turning on the audit database for the appropriate events ? Now  the SQL Auditing is also available to monitor even data access.

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

Apart from a runaway process, one other activity that often increases the journal by leaps and bounds are bulk data loads, often in an data warehouse/datamart environment. I am sure Tani would cover this use case in  his future address about minimizing it.

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