2.5.3.1.8 Transfer Database Objects
The Transfer Database Objects task object uses the PersistStorage structure to store its properties and collections.
The class ID of the Transfer Database Objects task object is (0x1002090E, 0xEB1C, 0x11CF, 0xAE, 0x6E, 0x0, 0xAA, 0x0, 0x4A, 0x34, 0xD5).
The persistent property set for the Transfer Database Objects task object contains the following items.
|
Property |
Type |
Description |
|---|---|---|
|
Name |
BSTR |
Specifies the name of the task. |
|
Description |
BSTR |
Specifies the description of the task or lineage. |
|
SourceServer |
BSTR |
Specifies the server to use for the source. |
|
SourceLogin |
BSTR |
Specifies the login to use against the source server. |
|
SourcePassword |
BSTR |
Specifies the password to use against the source server. |
|
SourceDB |
BSTR |
Specifies the database to use in the source server. |
|
DestinationServer |
BSTR |
Specifies the server to use for the destination. |
|
DestinationLogin |
BSTR |
Specifies the login to use on the destination server. |
|
DestinationPassword |
BSTR |
Specifies the password to use on the destination server. |
|
DestinationDB |
BSTR |
Specifies the database to use on the destination server. |
|
ScriptDirectory |
BSTR |
Specifies the location where generated scripts are to be saved. |
|
SourceTrustedLogin |
BOOL |
Specifies whether to use a trusted connection.<24> |
|
DestinationTrustedLogin |
BOOL |
Specifies whether to use a trusted connection.<25> |
|
IncludeDependencies |
BOOL |
Specifies whether to include all dependent objects. If TRUE, all dependent objects are included. If FALSE, all dependent objects are not included. |
|
IncludeLogin |
BOOL |
Specifies whether to include logins from the source. If TRUE, logins from source are included. If FALSE, logins from source are not included. |
|
IncludeUsers |
BOOL |
Specifies whether to include users and roles from the source. If TRUE, users and roles from the source are included. If FALSE, users and roles from the source are not included. |
|
DropDestObjects |
BOOL |
Specifies whether to drop the destination object first. If TRUE, the destination object is dropped first. If FALSE, the destination object is not dropped first. |
|
CopySchema |
BOOL |
Specifies whether to transfer schema from the source to the destination. If TRUE, schema is transferred from source to destination. If FALSE, schema is not transferred from source to destination. |
|
CopyDataOption |
LONG |
Specifies a bitmask for use with the CopyDataOption value. For more information, see the CopyDataOption value table later in this section. |
|
ScriptOption |
LONG |
Specifies scripting options. For more information, see the ScriptOption value table later in this section. |
|
ScriptOptionEx |
LONG |
Specifies extended scripting options. For more information, see the ScriptOptionEx value table later in this section. |
|
CopyAllObjects |
BOOL |
Specifies whether to copy all objects. If TRUE, all objects are copied. If FALSE, all objects are not copied. |
|
SourceTranslateChar |
BOOL |
Specifies whether to translate from the source character set. If TRUE, the source character set is translated. If FALSE, the source character set is not translated. |
|
DestTranslateChar |
BOOL |
Specifies whether to translate to the destination character set. If TRUE, the destination character set is translated. If FALSE, the destination character set is not set. |
|
DestUseTransaction |
BOOL |
Specifies a destination operation in one transaction. If TRUE, a destination operation is specified. If FALSE, a destination operation is not specified. |
|
UseCollation |
BOOL |
Specifies the use destination's collation. |
The CopyDataOption value can have one or more of the following bits set.
|
Option |
Value |
|---|---|
|
ReplaceData |
0x0001 |
|
AppendData |
0x0002 |
The ScriptOption value can have one or more of the following bits set.
|
Option |
Value |
|---|---|
|
Include object drops. |
0x00000001 |
|
Include object permissions. |
0x00000002 |
|
Include object creation. |
0x00000004 |
|
Include clustered index creation. |
0x00000008 |
|
Include script triggers. |
0x00000010 |
|
Include script database permissions. |
0x00000020 |
|
Script to file only. |
0x00000040 |
|
Include rule/default bindings. |
0x00000100 |
|
Do not include declarative referential integrity (DRI). For more information about DRI, see [MSDN-POADB]. |
0x00000200 |
|
Convert user-defined types to base type. |
0x00000400 |
|
Include "if not exists". |
0x00001000 |
|
Include nonclustered index creation. |
0x00002000 |
|
Script aliases. |
0x00004000 |
|
Do not append "go" to commands. |
0x00008000 |
|
Script DRI indexes as indexes for noDRI. |
0x00010000 |
|
Include descriptive headers in output. |
0x00020000 |
|
Owner-qualify DROP [CREATE] statements. |
0x00040000 |
|
Convert timestamp columns to binary. |
0x00080000 |
|
Append sorted_data for clusters. |
0x00100000 |
|
Append sorted_data and fillfactor for clusters. |
0x00200000 |
The ScriptOptionEx value can have one or more of the following bits set.
|
Option |
Value |
|---|---|
|
SET ANSI PADDING on/off before CREATE TABLE. |
0x00000001 |
|
Generate ANSI output file. |
0x00000002 |
|
Generate UNICODE output file. |
0x00000004 |
|
Ignore errors in script file generation. |
0x00000008 |
|
Do not generate 'ON <fg>' for replication. |
0x00000010 |
|
Mark system triggers (replication only). |
0x00000020 |
|
Only script user triggers (replication only). |
0x00000040 |
|
Script encrypted password. |
0x00000080 |
|
Script XP to a separate file. |
0x00000100 |
|
Do not script what-if indexes. |
0x00000200 |
|
Script notification for SQL Agent. |
0x00000400 |
|
Include job in alert scripting. |
0x00000800 |
|
Include full-text index scripting. |
0x00080000 |
|
Include the security identifier (SID) for standard logins.<26> |
0x00100000 |
|
Include full-text catalog scripting. |
0x00200000 |
|
Include extended property scripting. |
0x00400000 |
|
Do not script collation clauses.<27> |
0x00800000 |
|
Do not use certain features in the output script.<28> |
0x01000000 |
|
Disable job at end of job creation. |
0x02000000 |