Description:
During the full export job to the SQL Server database table in Infoworks v2.x,v3.x,v4.x, the SQL server table will be dropped and re-created as it is a full export job.
Sometimes, if your external applications read the data from this SQL server table and if you want to persist the table and prevent the table from being re-created, configure the Primary Key index for the export table in the export configurations.
After this, table wont be created for every run using default configurations (full_export_overwrite_table=true). Currently, for a non-indexed table, there is no configuration to skip table creation, the above configuration only works for an indexed table.
https://docs2x.infoworks.io/export-data/sql-server-export
Applicable Infoworks Versions:
v2.x,v3.x,v4.x