Database writers offer a "Table Handling" property with a "Truncate Existing" Option.
This option may be inefficient if a foreign key constraint has been set on the table. A simple solution would be to implement a "Truncate Cascade Existing" Option.
+15- Safer
As a best practice, it is recommended to use the SQL to Run Before parameter on any database writer to handle truncate cascade. For more information see the documentation: https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/sqlserver_jdbc/sqlserver_jdbc_writer.htm This idea relates to https://community.safe.com/ideas/for-feature-type-table-handling-truncate-if-exists-create-if-needed-28782
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.