Triggers with DBLoader on SQL Server

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Licences AAW
Posts: 10
Joined: Tue 21 Jul 2015 07:43

Triggers with DBLoader on SQL Server

Post by Licences AAW » Tue 08 Dec 2015 10:34

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]

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Triggers with DBLoader on SQL Server

Post by azyk » Fri 11 Dec 2015 10:09

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.

Licences AAW
Posts: 10
Joined: Tue 21 Jul 2015 07:43

Re: Triggers with DBLoader on SQL Server

Post by Licences AAW » Mon 14 Dec 2015 13:18

Hi,

good news. :)
thx for the answer

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Triggers with DBLoader on SQL Server

Post by azyk » Thu 05 May 2016 12:22

SpecificOptions 'SQL Server.FireTrigger' for TUniLoader was added to UniDAC 6.3.12.

Post Reply