Transfer Script Mode Constants (SQLDMO_XFRSCRIPTMODE_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.
Transfer script mode constants direct behavior of the ScriptTransfer method of the Database object.
Constant |
Value |
Description |
|---|---|---|
SQLDMOXfrFile_Default |
1 |
SQLDMOXfrFile_SummaryFiles. |
SQLDMOXfrFile_SingleFile |
2 |
Generates one file. |
SQLDMOXfrFile_/SingleFilePerObject |
4 |
Generates one file for each Microsoft SQL Server component transferred. |
SQLDMOXfFILE_/SingleSummaryFile |
8 |
Generates one file. The file contents are organized by object type. |
SQLDMOXfrFile_SummaryFiles |
1 |
Generates one file for each kind of object transferred. For example, it generates a file for user-defined data types and a separate file for tables. |