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
*
SQL Server DBA Videos
*
SQL Programming Video Training
*
More Videobooks...
Search
My Account
More Videobooks
Sign in
Home
FREE Video Tutorials
Subscriber Video Tutorials
Subscriptions
FAQs
Our Other Sites
About Us
Home
Free Videos
Subscriber Videos
Buy Now (Subscriptions)
More Video Websites
Search for Videos
Tag Cloud
Subscriptions
Subscribe!
Testimonials
List of Videobooks
Quick Links
About the Author
Login
FAQs
Site Map
Pt. 1 - An Introduction to SQL Server Management Studio (SSMS)
Pt. 1- Introduction to SQL Server 2005's Integration Services
Pt. 3 - Using Proxies and Credentials When Scheduling Your SSIS P...
Pt. 1 - What Are Package Configurations and How Can I Use Them?
Formatting Options in SSIS - How to Make Your Packages More Manag...
Integration Services Videos in Series
Home
Subscriber Videos
How to Move and Copy Databases to a New Server/Instance
- Video Series
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:
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
Company News
»
We're also sponsoring the St Louis SQL Server User Group July 9
»
We're sponsoring the Billings, Montana .NET User Group July 8
»
We're sponsoring the San Antonio, TX Alamo Coders User Group June 10th
»
Scott had a baby!
Home
|
About Us
|
Advertising
|
Become an Author
|
Contact Us
|
Privacy
|
System Req's
|
Terms
|
Testimonials
|
Work for Us!
|
|
Site Map
© 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.
8/7/2008 2:46:54 PM