CopyData Property

SQL-DMO

CopyData Property

The CopyData property controls data transfer from a source to a target database.

Applies To

Transfer Object

Syntax

object.CopyData [= value]

object

Expression that evaluates to an object in the Applies To list

value

Long integer that specifies data handling as described in Settings

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetCopyData(
SQLDMO_COPYDATA_TYPE* pRetVal);

HRESULT SetCopyData(
SQLDMO_COPYDATA_TYPE NewValue);

Settings

Constant	Value	Description
SQLDMOCopyData_Append	2	Copy data. Data copied will be appended to existing tables.
SQLDMOCopyData_False	0	Do not copy data. Copy schema only.
SQLDMOCopyData_Replace	1	Copy data. Existing data will be replaced by data copied.

Remarks

When CopyData is SQLDMOCopyData_Replace, and the DropDestObjectsFirst property is FALSE, data is removed from existing tables on the target database using a bulk-logged operation. For more information, see TRUNCATE TABLE.