Database Transfer Task(SSIS)

Database Transfer Task is used to copy or move the database objects(mdf and ldf files) from one instance to another instance or one server to another server. 

Properties : Few common proprieties on General tab such as Name and Description, depends on your requirements. 
On Database Tab, we will need to specify the Source and Destination Connection of the MS SQL Server instances.
Specify the source and destination database for copying the required files.

Method of copying or moving the database files states how you want to perform the operation.

Offline & Online are the two methods available.

• In online mode the operations are performed in connection with the servers.
• In offline mode the operations are performed after disconnecting with the server and copying or moving is done. It will reconnect after the operation is done. In offline mode the database is not available for any other resources.

Note : In Offline mode make sure that you got the correct network path for database files.

Overwrite Existing, can be used when there is a scenario of daily operations for same database where you want to the same database.

Reattach Source Database is enabled only we select offline method. This flag will reattach the database file to the instances if the task fails for any reason.

For copying all the other objects using SSIS, you can use Transfer SQL Server Objects Task. It opens a wide range of options for accessing all the objects in SQL Server.

P.S :  I am a beginner in MSBI and trying to learn. Please comment below.