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.