Bulk Insert Task: This task offers an efficient way to copy large volumes of data.
Execute SQL Task: This task allows the execution of a SQL statement. If the statement returns results, they can be stored in a variable.
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.
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 Jobs Task: This task will transfer a single or multiple SQL Server Agent jobs between SQL Server instances.
Transfer Logins Task: This task will transfer a single or multiple SQL Server logins between SQL Server instances.
Transfer Master Stored Procedures Task: This task will transfer a single or multiple SQL Server Master database stored procedures between SQL Server instances.
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.
No comments:
Post a Comment