SQL-DMO
Data Copy Constants (SQLDMO_COPYDATA_TYPE)
Data copy constants specify inclusion and behavior for table data when the Transfer object is used to copy schema or data from one instance of Microsoft® SQL Server™ to another.
| 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. |