Transfer Method

Description

Performs a database transfer by copying specified objects and data to the destination database. Set the properties of a created Transfer object as desired, pass that Transfer object to the ScriptTransfer method with tScriptMode set to SQLOLEXfrFile_SummaryFiles to create the script files, and then pass the same Transfer object to the Transfer method to perform the database transfer.

If the ScriptTransfer method is not called first, the Transfer method will call ScriptTransfer with tScriptMode set to SQLOLEXfrFile_SummaryFiles and strFile set to the current directory to create the summary script files.

Visual Basic

Database.Transfer ( [TransferSpec :=] Transfer )

C++

HRESULT pDatabase->Transfer ( LPSQLOLETRANSFER pTransfer );

Elements

Remarks

The Transfer method does not remove objects or data from the source database.

The Transfer method creates three types of error log files:

• One source error log contains errors from the source SQL Server and database and has a filename of the following form:

  source_server.source_database.LOG

  where source_server is the name of the SQL Server that contains the source database, and source_database is the name of the source database.

• One destination error log contains errors from the destination SQL Server and database and has a filename of the following form:

  destination_server.destination_database.LOG

  where destination_server is the name of the SQL Server that contains the destination database, and destination_database is the name of the destination database.

• Multiple bulk copy error log files contain errors from the bulk copy of data from each table, and each has a filename of the following form:

  owner.table.BCP

  where owner is the username of the object owner, and table is the name of the table.