Transfer Database Task
The Transfer Database task transfers a database from the source SQL Server to the destination SQL Server; you can copy or move your database. This task can use DatabaseOnline or DatabaseOffline method of transfer. When you choose online transfer of the database, the source database stays online even during transfer and can respond to user queries; in the offline method, the source database is detached and the database files are copied over to the destination server. You can specify to reattach the source database or leave it offline.
You configure the Transfer Database task in the following ways:
Once you open the task editor, you will see three pages: General, Databases, and Expressions. You specify name and description ...
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.
