Analysis Services Execute DDL Task

Analysis Services Execute DDL Task: This task will run data definition language statements on Analysis Services. This allows for the create, drop, alter of cubes, dimensions and mining models.

Transfer SQL Server Objects Task

Transfer SQL Server Objects Task: This task will transfer a single or multiple SQL Server database objects between SQL Server instances. Most of SQL Servers DDL objects can be copied with this task.

Transfer Master Stored Procedures Task

Transfer Master Stored Procedures Task: This task will transfer a single or multiple SQL Server Master database stored procedures between SQL Server instances.

Transfer Logins Task

Transfer Logins Task: This task will transfer a single or multiple SQL Server logins between SQL Server instances.

Transfer Jobs Task

Transfer Jobs Task: This task will transfer a single or multiple SQL Server Agent jobs between SQL Server instances.

Transfer Error Messages Task

Transfer Error Messages Task: This task will transfer a single or multiple SQL Server user defined error messages between SQL Server instances. It can be setup to transfer specific user messages or all error messages.

Transfer Database Task

Transfer Database Task: This task will copy or move a SQL Server database between two instances of SQL Server. It can even be used to make a copy of a database on the same server. Databases can be copied either online or offline.