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 …

Sharing an Incremental script for sync between Exact Online and SQL Server

Vragen (en)

sda November 28, 2024, 7:57am 6

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

Incremental gegevens laden Exact Online

Topic		Replies	Views
Updated synchronization script between Eol and SQL server Vragen (en) exact-online , invantive-query-tool , performance , sql-server	4	21	January 29, 2026
Replicatie grote Exact Online tabel (>20 miljoen boekingen) Wiki (alle) exact-online , invantive-data-hub	0	52	October 2, 2024
Synchronize inside a loop seems not working Vragen (en) exact-online , invantive-sql , synchronize	3	164	March 21, 2024
Voorbeeld aanmaken relaties in Exact Online Vragen (alle) exact-online	1	10	January 23, 2026
Itgeneor823 foutmelding bij draaien script Vragen (alle) exact-online , invantive-query-tool , sql-server	4	22	January 29, 2026

Sharing an Incremental script for sync between Exact Online and SQL Server

Related topics