CHECK_CONSTRAINTS for bulk insert

When we use the "Bulk export to database" action, with a SQL server as target, there is no check on the foreign keys. In SQL Server there is an option for the bulk insert (CHECK_CONSTRAINTS ) that can specify that all constraints on the target table must be checked.
Can we add an option to enable this option?
(I known that we can also use the normal "Export to database" action for this, but performance will be worse, so this option would be preferred).

BULK INSERT (Transact-SQL) - SQL Server | Microsoft Learn

1 Like

Hello @dgudkov, all,

Have you had a chance to review Wouter's observation above? Would you consider adding the option to check table constraints to the roadmap?

Thanks!

Yes, we will add an option for that in the next release.

2 Likes