Data Copy Constants (SQLDMO_COPYDATA_TYPE)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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	Copies data. Copied data is appended to existing tables.
SQLDMOCopyData_False	0	Does not copy data. Only the schema is copied.
SQLDMOCopyData_Replace	1	Copies data. Copied data replaces existing data.