Subject | Re: [Firebird-Architect] Bulk loader. |
---|---|
Author | Roman Rokytskyy |
Post date | 2007-11-04T08:03:29Z |
>> Is that your personal opinion or result of the discussion with peopleOk.
>> that asked this feature?
>
> Its my personal opinion based on profling of different FB operations such as
> insert and FK index build.
>> What about other engines like Oracle or MS SQL?What happens when bulk insert brings database into inconsistent state?
>
> 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 means does admin have to repair the database (restore consistency)?
> PermissionsHmmm... personally I would go with GRANT BULK INSERT ON <...> TO <...> .
> Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.
Roman