Transfer Master Stored Procedures Task
The Transfer Master Stored Procedures task copies user-defined stored procedures that are stored in the master database of the source SQL Server instance to the master database of the destination SQL Server instance. Following are the steps you would take to configure this task:
1. | Specify the name and the description for the task in the General page of the editor window. |
2. | Specify the source and destination connections using the SMO Connection Manager. |
3. | Choose to copy all or specific stored procedures defined in the master database in the TransferAllStoredProcedures field. You can select the stored procedures from the list provided in the StoredProceduresList field if you choose to transfer only the specific ... |
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
