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 series include:

• 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
• Using the SQL Server 2005 Database Publishing Wizard to deploy locally developed databases to a hosted environment (i.e., a web host)
  
• Who should use the SSDPW
  
• How to deploy SQL databases in APP_DATA folder to a web host using the SSDPW
  
• Scripting options in the SSDPW
• Differences between the scripting options in SSMS (SP2) and the SSDPW

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