Subject Re: [Firebird-Architect] Bulk loader.
Author Roman Rokytskyy
>> Is that your personal opinion or result of the discussion with people
>> that asked this feature?
>
> Its my personal opinion based on profling of different FB operations such as
> insert and FK index build.

Ok.

>> What about other engines like Oracle or MS SQL?
>
> MSSQL have command-line BCP (buck copy) utility and BULK INSERT
> statement and allow to ignore any constraints and disable insert triggers.
> More - this is default behavior :
> [...]

What happens when bulk insert brings database into inconsistent state?
What means does admin have to repair the database (restore consistency)?

> Permissions
> Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.

Hmmm... personally I would go with GRANT BULK INSERT ON <...> TO <...> .

Roman