IncludeDB Property

SQL-DMO

SQL-DMO

IncludeDB Property

The IncludeDB property specifies whether to create a database on the destination server during a data transfer operation.

Applies To
Transfer2 Object
Syntax

object.IncludeDB [= value]

Parts

Object

Expression that evaluates to an object in the Applies To list

Value

TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetIncludeDB( LPBOOL pRetVal);

HRESULT SetIncludeDB(BOOL NewValue);

Remarks

With the IncludeDB property set to TRUE, a database need not already exist at a destination server before database objects can be copied during a transfer operation. The IncludeDB property generates a destination database creation statement at the beginning of script execution during a transfer operation.

The default is FALSE.

Note  IncludeDB can be used with Microsoft® SQL Server™ 2000 and SQL Server version 7.0.