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.