Transfer Logins Task Editor (Logins Page)

SourceConnection

Select a SMO connection manager in the list, or click <New connection...> to create a new connection to the source server.

DestinationConnection

Select a SMO connection manager in the list, or click <New connection...> to create a new connection to the destination server.

LoginsToTransfer

Select the SQL Server logins to copy from the source to the destination server. This property has the options listed in the following table:

Value	Description
AllLogins	All SQL Server logins on the source server will be copied to the destination server.
SelectedLogins	Only logins specified with LoginsList will be copied to the destination server.
AllLoginsFromSelectedDatabases	All logins from the databases specified with DatabasesList will be copied to the destination server.

LoginsList

Select the logins on the source server to be copied to the destination server. This option is only available when SelectedLogins is selected for LoginsToTransfer.

DatabasesList

Select the databases on the source server that contain logins to be copied to the destination server. This option is only available when AllLoginsFromSelectedDatabases is selected for LoginsToTransfer.

IfObjectExists

Select how the task should handle logins of the same name that already exist on the destination server.

This property has the options listed in the following table:

Value	Description
FailTask	Task fails if logins of the same name already exist on the destination server.
Overwrite	Task overwrites logins of the same name on the destination server.
Skip	Task skips logins of the same name that exist on the destination server.

CopySids

Select whether the security identifiers associated with the logins should be copied to the destination server. CopySids must be set to True if the Transfer Logins task is used along with the Transfer Database task. Otherwise, the copied logins will not be recognized by the transferred database.

Reference

Concepts