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 …

Deling af et inkrementelt script til synkronisering mellem Exact Online og SQL Server

Spørgsmål (en)

sda 28. November 2024, 07:57 6

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

Incremental gegevens laden Exact Online

Emne		Svar	Visninger
Updated synchronization script between Eol and SQL server Vragen (en) exact-online , invantive-query-tool , performance , sql-server	4	21	29. Januar, 2026
Replicatie grote Exact Online tabel (>20 miljoen boekingen) Wiki (alle) exact-online , invantive-data-hub	0	52	2. Oktober, 2024
Synchronize inside a loop seems not working Vragen (en) exact-online , invantive-sql , synchronize	3	164	21. Marts, 2024
Tables replication automation with stored procedure giving statistics & error handling by email Wiki (en) exact-online , invantive-query-tool , invantive-data-hub , invantive-psql	1	665	16. Februar, 2022
Modern way to incrementally replicate Exact Online Vragen (en) exact-online , invantive-sql	2	142	6. Maj, 2024

Deling af et inkrementelt script til synkronisering mellem Exact Online og SQL Server

Related topics