I was wondering what a modern Invantive SQL script would look like that replicates most of Exact Online to a PostgreSQL database and does so as incrementally as possible. I’ve found this script, but it doesn’t seem to be using the incremental tables.
How could the first script be enhanced to use the incremental tables?
The script still applies and is in general the recommended way to replicate the data for most platforms. To use the incremental tables just replace the table names.