SQL-DMO
Transfer Script Mode Constants (SQLDMO_XFRSCRIPTMODE_TYPE)
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 | Generate one file. |
| SQLDMOXfrFile_SingleFilePerObject | 4 | Generate one file for each Microsoft® SQL Server™ component transferred. |
| SQLDMOXfFILE_SingleSummaryFile | 8 | Generate one file. File contents organized by object type. |
| SQLDMOXfrFile_SummaryFiles | 1 | Generate one file for each kind of object transferred. For example, generate a file for user-defined data types and a separate file for tables. |