Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Videos · SQL Programming Video Training
   
SQL Server Integration Services Training Videos
Integration Services Videos in Series Home  Subscriber Videos  

How to Move and Copy Databases to a New Server/Instance (Video Series)

Video Image Video Category: Miscellaneous - Topics That Do Not Fit Anywhere Else!

Skill Level: 300 (Intermediate)

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
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

Videos in this Series:



Other Websites We Offer
LearnCSharp.com
Don't Forget!
100% Money Back Guarantee
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
12/5/2008 2:23:43 AM