|
Home > Archive > Microsoft SQL Server forum > November 2005 > Regarding BCP utility
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Regarding BCP utility
|
|
| pankaj_wolfhunter@yahoo.co.in 2005-11-29, 3:23 am |
| Greetings,
Just wanted to know if there is any parameter in BCP
utility that can ignore triggers, indexes and constraint defined for a
table?
any help will be greatly appreciated
TIA
| |
|
| No there isn=B4t, the only option would be to disable them prior sending
the actual statement.
HTH, Jens Suessmeyer.
| |
| pankaj_wolfhunter@yahoo.co.in 2005-11-29, 3:23 am |
| Actual i read something in BCP doc as below
"
-h "hint [,...n]"
Specifies the hint(s) to be used during a bulk copy of data into a
table or view. This option cannot be used when bulk copying data into
SQL Server 6.x or earlier.
Hint Description
CHECK_CONSTRAINTS Any constraints on the destination table are checked
during the bulk copy operation. By default, constraints are ignored.
Note that the max_errors option does not apply to constraint checking.
FIRE_TRIGGERS Specified with the in argument, any insert triggers
defined on the destination table will execute during the bulk copy
operation. If FIRE_TRIGGERS is not specified, no insert triggers will
execute. FIRE_TRIGGERS is ignored for the out, queryout, and format
arguments.
"
Does this mean that constraints and insert triggers will not be
checked, if not specified with this option?
|
|
|
|
|