Understood - I am not ‘directly’ writing SQL tables, I am letting DMT perform that task, as hopefully it knows the schema to write/modify the Epicor tables - I’m only querying the ECM and ERP tables, not performing any writes within SQL. I am very careful to not perform any writes to the databases that don’t go through an ECM/Epicor interface/method/etc… I hope that the worst that I’d break is the document attachment links within Epicor (presumably no worse than someone deleting/moving the document without updating the link). I plan to export the existing data so I can DMT it back if I break it
Larger question now: Are there any concerns with pointing multiple Epicor attachment references to the same ECM document/link (for the boiler-plate documents)?
Thanks for the help @MikeGross - it is much appreciated!