New SQL Server 2005 Video Tutorial: Options Available for Moving Databases From One Instance/Server to Another

Options Available for Moving Databases From One Instance/Server to Another - view details

One of the most common questions that Scott Whigham (author of this site) gets is, 'How do I move/copy a database from ServerA to ServerB?' and this series is meant to help you understand the options available and how to do the copy/move.

This video is just an overview of the options for moving databases around your environment are; it is not a demo/tutorial, per se. You'll definitely want to watch the other videos in this series to view the demo/tutorials.

Highlights from this video:

• Options for migrating SQL 2000 to SQL 2005 and SQL 2005 to SQL 2005
  
• Differences between an upgrade and a migration
  
• Backup/Restore
  
• Detach/Attach
  
• SQL Server Integration Services (SSIS) Tasks
  
• Scripting with the SQL Server 2005 Database Publishing Wizard

and much more. NOTE: During the lecture, Scott makes a typo in the discussion of database compatibility levels. The correct stored procedure should be sp_dbcmptlevel

---

• Source: http://www.learnsqlserver.com
• Category: Database Creation, Management and Best Practices
• Skill Level: 300 (Intermediate)
• Length: 12:30 (8.73MB)
• Applies to Versions: SQL Server - All Versions
• 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: migrate, upgrade, upgrading, migration, backup and restore, restoring, detaching, how to