473,396 Members | 1,706 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Regarding BCP utility

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

Nov 29 '05 #1
2 1283
No there isn´t, the only option would be to disable them prior sending
the actual statement.

HTH, Jens Suessmeyer.

Nov 29 '05 #2
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?

Nov 29 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Azhar Bilgrami | last post by:
Dear Hi: Hope to see u in good health. " I want to migrate a database which is currently running Unix as Operating System and Oracle ver 6 as Database, it is also using oracle froms version 3...
1
by: invincible | last post by:
hi, assume my program is running , is there a way I can dump its core in solaris, in linux i think u can use gcore Mohan
5
by: Diffident | last post by:
Hello All, I have written a webform which is by default derived from "Page" class. I have coded another utility class with few methods and an object of this class is instantiated from the webfom...
7
by: pankaj_wolfhunter | last post by:
Greetings, While loading data into Sql Server using BCP utility, we have to explicitly need to drop the indexes. then after loading the data we recreate them. I just want to know if this is...
1
by: huyuhui | last post by:
The following is a question of LOAD utility. Question: How does the DB2 enforce table check constraints for data added to table with the LOAD utility? A. With the BUILD phase of LOAD B. With the...
5
by: Ted | last post by:
I am working on two versions of an application, one of which will be a windows forms application (which will need to be redistributable) and the other will be a web application. I have MS Visual...
4
by: noone | last post by:
Hi. I've got a fella working for me who is trying to convince me to change our coding standards to using separate .h and .cc files for definitions and implementations. I know this is a...
3
by: aakn30 | last post by:
Dear friend, I need to import text file into oracle .I am using oracle 10g. The text file contains blank space for some lines and the next line (which is having data )appear some 10 lines after...
3
by: anoopmv | last post by:
hi guys im trying to write a program that implements a utility for counting no.of characters,words and lines in specified file A sample execution of such utility is shown below. The utility...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.