Page 1 of 1

Triggers with DBLoader on SQL Server

Posted: Tue 08 Dec 2015 10:34
by Licences AAW
Hello,

DBLoader on SQLServer uses IRowsetFastLoad interface which support an "FIRE_TRIGGERS" option (allows table triggers to be fired during insertion, deactivated by default).
But, it seems DBLoader specific options doesn't allow to activate this option.

Did I miss something, or is this option not implemented? (In that case, is it possible to add it?)

[Unidac 6.1.5]

Re: Triggers with DBLoader on SQL Server

Posted: Fri 11 Dec 2015 10:09
by azyk
Currently, such functionality is not implemented in UniDAC. We will add the possibility to set the FIRE_TRIGGER option using TUniLoader for SQL Server in one of the next UniDAC versions.

Re: Triggers with DBLoader on SQL Server

Posted: Mon 14 Dec 2015 13:18
by Licences AAW
Hi,

good news. :)
thx for the answer

Re: Triggers with DBLoader on SQL Server

Posted: Thu 05 May 2016 12:22
by azyk
SpecificOptions 'SQL Server.FireTrigger' for TUniLoader was added to UniDAC 6.3.12.