posted on Friday, March 11, 2005 9:24 AM
by
Knight_Reign
Transfer SQL Server objects tasks
Many have commented to me about the lack of transfer tasks or asked about the Integration Services story for the transfer tasks.
I'm happy to say that we will have tasks that are compatible with and will upgrade from the DTS tasks.
They will use a new SMO connection manager.
- Transfer Database Task
- Transfer SQL Server Objects Task
- Transfer Stored Procedures Task
- Transfer Logins Task
- Transfer Jobs Task
The Transfer Database Task transfers an entire database either by attach/detach or online mode. The Transfer SQL Server Objects Task is the new replacement for the Copy SQL Server Objects Task and allows you more flexibility to move objects such as schema, tables, primary keys, etc. along with the other types of objects.
I'm not sure when these will make it to your desktop, but it should be soon.
Universe.Earth.Software.Microsoft.SQLServer.IS.KirkHaselden