| Property | Description |
|---|
| Application Application Write: No |
The Application object. |
| CopyAllDefaults Boolean Write: Yes |
Determines if all defaults in the source database are copied. If True, all defaults in the source database are copied to the destination database. If False, use the AddObject or AddObjectByName method to add a default to the list of copied objects. |
| CopyAllObjects Boolean Write: Yes |
Determines if all objects in the source database are copied. If True, all objects in the source database are copied to the destination database, and all other CopyAllObjects properties are ignored. If False, the other CopyAllObjects properties and the AddObject and AddObjectByName methods are used. |
| CopyAllRules Boolean Write: Yes |
Determines if all rules in the source database are copied. If True, all rules in the source database are copied to the destination database. If False, use the AddObject or AddObjectByName method to add a rule to the list of copied objects. |
| CopyAllStoredProcedures Boolean Write: Yes |
Determines if all stored procedures in the source database are copied. If True, all stored procedures in the source database are copied to the destination database. If False, use the AddObject or AddObjectByName method to add a stored procedure to the list of copied objects. |
| CopyAllTables Boolean Write: Yes |
Determines if all tables in the source database are copied. If True, all tables in the source database are copied to the destination database. If False, use the AddObject or AddObjectByName method to add a table to the list of copied objects. |
| CopyAllTriggers Boolean Write: Yes |
Determines if all triggers in the source database are copied. If True, all triggers in the source database are copied to the destination database. If False, use the AddObject or AddObjectByName method to add a trigger to the list of copied objects. |
| CopyAllUserDefinedDatatypes Boolean Write: Yes |
Determines if all user-defined datatypes in the source database are copied. If True, all user-defined datatypes in the source database are copied to the destination database. If False, use the AddObject or AddObjectByName method to add a user-defined datatype to the list of copied objects. |
| CopyAllViews Boolean Write: Yes |
Determines if all views in the source database are copied. If True, all views in the source database are copied to the destination database. If False, use the AddObject or AddObjectByName method to add a view to the list of copied objects. |
| CopyData SQLOLE_COPYDATA_TYPE Write: Yes |
If and how data will be copied to the destination database. If set to SQLOLECopyData_False, data is not copied. If set to SQLOLECopyData_Replace, destination tables are truncated, and then data is copied to them. If set to SQLOLECopyData_Append, data is appended to destination tables. |
| CopySchema Boolean Write: Yes |
Determines if objects that are copied from the source database are first created. If True, copied objects are created in the destination database before copying data. If False, no objects are created in the destination database, only the data is transferred from copied tables, and these tables must already exist in the destination database. |
| DestDatabase Identifier Write: Yes |
The database on the destination SQL Server that will store the objects and data from the source database. |
| DestLogin Identifier Write: Yes |
The login that is used to connect to the destination SQL Server. |
| DestPassword Identifier Write: Yes |
The password that is used to connect to the destination SQL Server. |
| DestServer String Write: Yes |
The name of the SQL Server that contains the destination database. |
| DestUseTrustedConnection Boolean Write: Yes |
Determines if a secure connection is requested when connecting to the destination SQL Server. If True, a secure connection is requested. If False, a normal connection is requested. |
| DropDestObjectsFirst Boolean Write: Yes |
Determines if copied objects are dropped first. If True, copied objects are first dropped from the destination database, and the CopySchema property must be set to True to recreate the copied objects. If False, copied objects are not dropped from the destination database. |
| IncludeDependencies Boolean Write: Yes |
Determines if objects that copied objects depend upon are automatically included in the list of copied objects. If True, any objects that a copied object depends upon is automatically included in the list of copied objects. If False, no dependency checking is done, and no objects are automatically included. |
| IncludeGroups Boolean Write: Yes |
Determines if all groups in the source database are copied. If True, all groups in the source database are created in the destination database. If False, no groups are copied. |
| IncludeLogins Boolean Write: Yes |
Determines if all SA-created logins in the source server's master database SQL Server are copied. If True, all SA-created logins in the source server's master database are created in the destination server's master database. If False, no SA-created logins are copied. |
| IncludeUsers Boolean Write: Yes |
Determines if all users in the source database are copied. If True, all users in the source database are created in the destination database. If False, no users are copied. |
| Parent Application Write: No |
The Application object. |
| ScriptType SQLOLE_SCRIPT_TYPE Write: Yes |
The type of information and operations to include in the scripts that are used to create the copied objects in the destination database. |
| TypeOf SQLOLE_OBJECT_TYPE Write: No |
The type of object. |
| UserData Long Write: Yes |
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property. |