Transfer Master Stored Procedures Task Editor (Stored Procedures Page)

Use the Stored Procedures page of the Transfer Master Stored Procedures Task Editor dialog box to specify properties for copying one or more user-defined stored procedures from the master database in one instance of SQL Server instance to a master database in another instance of SQL Server. For more information about this task, see Transfer Master Stored Procedures Task.

Note

This task transfers only user-defined stored procedures owned by dbo from a master database on the source server to a master database on the destination server. Users must be granted the CREATE PROCEDURE permission in the master database on the destination server or be members of the sysadmin fixed server role on the destination server to create stored procedures there.

Options

  • 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.

  • IfObjectExists
    Select how the task should handle user-defined stored procedures of the same name that already exist in the master database on the destination server.

    This property has the options listed in the following table:

    Value

    Description

    FailTask

    Task fails if stored procedures of the same name already exist in the master database on the destination server.

    Overwrite

    Task overwrites stored procedures of the same name in the master database on the destination server.

    Skip

    Task skips stored procedures of the same name that exist in the master database on the destination server.

  • TransferAllStoredProcedures
    Select whether all user-defined stored procedures in the master database on the source server should be copied to the destination server.

    Value

    Description

    True

    Copy all user-defined stored procedures in the master database.

    False

    Copy only the specified stored procedures.

  • StoredProceduresList
    Select which user-defined stored procedures in the master database on the source server should be copied to the destination master database. This option is only available when TransferAllStoredProcedures is set to False.