Copying in data with fast bcp

Table 3-2 summarizes the steps for copying in data to Adaptive Server using fast bcp.

Table 3-2: Steps for copying in data using fast bcp

Step

Who can do it

Use sp_dboption to set select into/bulkcopy/pllsort to true.

Run checkpoint in the database that was changed.

System Administrator or Database Owner

Have enough space to re-create any indexes and triggers on the table.

Drop the indexes and triggers on the table.

Table owner

Have insert permission on the table.

Granted by the table owner

Perform the copy with bcp.

Any user with insert permission

Re-create the indexes and triggers.

Table owner

Reset sp_dboption, if desired, and run checkpoint in the database that was changed.

System Administrator or Database Owner

Use dump database to back up the newly inserted data.

System Administrator, Operator, or Database Owner

Run stored procedures or queries to determine whether any of the newly loaded data violates rules.

Table owner or stored procedure owner