CopyAllObjects Property (SQL-DMO)

The CopyAllObjects property controls the transfer of Microsoft® SQL Server™ database objects from the source to the target database. SQL Server database objects are defaults, rules, stored procedures, tables, triggers, user-defined data types, and views.

Applies To

Transfer Object

Syntax

object.CopyAllObjects [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	True or False

Remarks

If True, all SQL Server database objects in the source database are copied to the target.

If False, only database objects indicated by the AddObject and AddObjectByName methods are copied.

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetCopyAllObjects(LPBOOL pRetVal);

HRESULT SetCopyAllObjects(BOOL NewValue);