New SQL Server 2005 Video Tutorial: How to Move a Database Using The Transfer Database Task in SSIS

How to Move a Database Using The Transfer Database Task in SSIS - view details

Here's yet another option for how to move a database from one server to another (or, 'how to copy a database from one instance to another'): the Transfer Database Task in SQL Server Integration Services (SSIS). The Transfer Database Task can be quite tricky to work with and isn't always the best option so you'll want to watch this video for a good overview before making it a part of your mission-critical operations.

---

• Source: http://www.learnsqlserver.com
• Category: Database Creation, Management and Best Practices
• Skill Level: 300 (Intermediate)
• Length: 12:47 (10.8MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: backups, restores, disaster recovery