How to Move and Copy Databases to a New Server/Instance - Video Series Video Category: Database Creation, Management and Best Practices 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:

Title Skill Length Download How to Copy a Database to a Web Host Using the SQL Server Database Publishing Wi...   200 10 mins. Download How to Move a Database Using Backup and Restore   200 9 mins. Download How to Move a Database Using Detach and Attach   200 11 mins. Download How to Move a Database Using The Transfer Database Task in SSIS   300 13 mins. Download Options Available for Moving Databases From One Instance/Server to Another   300 13 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Book You Should Probably Own: Ken England's "Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook" SQL Server 2000 Service Pack 3 Additions/Changes: New database role and server configuration to allow cross-database ownership chaining SQL Server 2000 Service Pack 3 Additions/Changes: Error reporting built into SQL Server