Skip to main content
Question

Upsert - recommendation on how to use?

  • April 10, 2026
  • 0 replies
  • 4 views

vxn43
Supporter
Forum|alt.badge.img+19

I have an address feature class in a SQL Server 2022 Enterprise Geodatabase. 

Some records have been updated in the attribute table and new records have been added. 

I want to write these updates and additions to another Enterprise Geodatabase and a File Geodatabase. 

Would the recommended approach be to use a ChangeDetector before each Writer and then use Upsert in each Writer?

OR 

Can I use Upsert in each Writer without using ChangeDetector?

 

Currently, the way I do this is to Truncate Existing in the Writer for the Enterprise Geodatabase and the Writer for the File Geodatabase. But, this can take a long time to run. It seems more efficient to use Upsert.