New SQL Server 2005 Video Tutorial: How to Copy a Database to a Web Host Using the SQL Server Database Publishing Wizard

How to Copy a Database to a Web Host Using the SQL Server Database Publishing Wizard - view details

The SQL Server Database Publishing Wizard (SSDPW) is yet another technique for moving databases from one server/instance to another (along with using backup/restore, detach/attach, and SSIS' Transfer Database Task).

Highlights from this video:

• 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

Link to the SSDPW (previously called the SQL Server Hosting Toolkit): download here

---

• Source: http://www.learnsqlserver.com
• Category: Database Creation, Management and Best Practices
• Skill Level: 200 (Beginner - Intermediate)
• Length: 9:30 (12.9MB)
• Applies to Versions: SQL Server 2005
• 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: webhost.