I share this script that does incremental update from the transactionlines@eol table into an @sqlserver table. It also sends reporting by email. The advantage of the script is that it circumvent the use of a create or replace table as select * from transactionlinesincremental@eol that runs quick on…

The script above has been updated with a correction on the deleted items (entitykey instead of id) select /*+ join_set(t2, id, 200000)*/ t1.id as id from to_delete@inmemorystorage t1 join transactionlines_sqlserver@sql_server t2 on t2.id = t1.EntityKey -- t1.id is the id of the deleted reco…

The script above was updated with a collateral bug related to the entityKey issue. the join was corrected, the r2.id was forgotten. Now replaced by r2.EntityKey -- delete the records to delete for r2 in ( select /*+ join_set(t2, id, 200000)*/ t1.id as id from to_delete@inmemorystorage t1 join tran…

The script above has been updated. The update consists of: better fault detection if either $count compare from @eol and @sqlserver do not match or inserted/updated/deleted records count after modifications in sql server are not as expected, the reporting email will indicate an error/failure …

Compartiendo un script incremental para sincronización entre Exact Online y SQL Server

Preguntas (en)

sda 28 Noviembre, 2024 07:57 6

The script has been corrected replacing the miswritten $rowid to rowid$.

Incremental gegevens laden Exact Online

Tema		Respuestas	Vistas
Updated synchronization script between Eol and SQL server Vragen (en) exact-online , invantive-query-tool , performance , sql-server	4	36	29 Enero 2026
Itgenclr217 goes unnoticed on Exact Online employees Vragen (en) exact-online , invantive-sql	3	32	1 Octubre 2026
Replicatie grote Exact Online tabel (>20 miljoen boekingen) Wiki (alle) exact-online , invantive-data-hub	0	53	2 Octubre 2024
Synchronize inside a loop seems not working Vragen (en) exact-online , invantive-sql , synchronize	3	168	21 Marzo 2024
Voorbeeld aanmaken relaties in Exact Online Vragen (alle) exact-online	1	14	23 Enero 2026

Compartiendo un script incremental para sincronización entre Exact Online y SQL Server

Temas relacionados