150 likes | 299 Vues
Explore the various content deployment options available in SharePoint, including SQL database backup and restore, the Content Deployment Tool (CDT), and custom code solutions. Understand the advantages and disadvantages of each method, from scheduling capabilities to user interfaces. Gain insights into technical considerations for syncing production and testing environments, managing user accounts, and configuring server topology. Whether you're a developer or an administrator, this guide provides essential information to streamline SharePoint content management effectively.
E N D
Take a Break -http://www.thetop10everything.com/top-10-geek-jokes There are 10 types of people in the world - those who know binary and those who have friends Q: Did you hear about the Coder that got stuck in his shower for a week? A: The instructions on his shampoo said: Lather, rinse, repeat. 1f u c4n r34d th1s u r34lly n33d t0 g37 l41d If at first you don't succeed; call it version 1.0 Q: How many programmers does it take to change a light bulb? A: None. It's a hardware problem. Q: How many IBM Processors does it take to execute a job? A: Four. Three to hold it down, and one to rip it's head off. Q: How can you tell if a geek is extroverted? A: He stares at your shoes.
Content Deployment Options SQL – Content database backup/restore OOTB – STSADM command OOTB - Content Deployment Tool (CDT) CodePlex - Content Deployment Wizard Custom Code - SP Import Export class
Tommy Segoro • Technical Lead @ L7 Solutions • tommy.segoro@l7.com.au • http://blog.completesharepoint.net • http://www.codeplex.com/completesharepoint • http://www.codeplex.com/spexportimport • I’m engaged...sorry...
What is CD Used For? • Synching Prod and Test content • Deploying separate content to Extranet • Backup/restore procedure
Pre-Check • Are both source + destination synched? • The server topology • The user accounts used to run MOSS/Sharepoint services (Search, SSP, etc etc) • The configurations (SSP config, Central Admin config, email settings, etc) • The solutions and features installed • The code and DLL deployed (even third party DLLs such as stsadm extensions, etc) • Web.config settings • IIS settings • SQL server settings • AD settings for each user account used in Test and Prod • The resource settings for both Prod and Test (RAM, Hard Disks, Processor Utilization, etc)
SQL Content Database Backup/Restore • Advantages: • Can be scheduled • Backup and restore the whole content of the site • Relatively easy to do • Various user interface • Central Admin • SQL Management Studio • Command Prompt • Disadvantages: • Slow • Backup file can be very big • Can’t export/import selective content
DEMO Jade Raymond Video Game Producer
OOTB STSADM Command • Advantages: • Can be scheduled through Windows Scheduled Task • Can export/import selective content at site level • Relatively easy to setup • Disadvantages: • Only command prompt user interface • Selective content is only at site level • No error trapping • Simply stops when encounters an error • Limited deployment options
OOTB Content Deployment Tool • Advantages: • Can be scheduled • Integrated with Central Admin user interface • User-friendly GUI • Disadvantages: • Very limited deployment options • Only export/import at site level • No error trapping • Simply stops when encounters an error
DEMO Olivia Munn Video Games Channel Host
CodePlex- Content Deployment Wizard • Advantages: • Rich GUI • Source code is downloadable • Many deployment options can be set • Export/import at any level (site, lists, list items) • Disadvantages: • Cannot be scheduled • No error trapping • Simply stops when encounters an error
Custom Code – SPImport/SPExport • http://www.codeplex.com/spexportimport • Advantages: • Do whatever you want • Access to full set of deployment options • Import/export at any level (sites, lists, list items) • Can be written as a scheduled service, etc • Error trapping, enterprise architecture, etc • Disadvantages: • Takes time to develop and test • Prone to bugs • UI has to be built separately otherwise command prompt
DEMO David Hasselhoff Whatever man you want him to be