Migrating Data

The SVMigrate tool helps you to migrate data from one system to another. The tool can also be used to restore SharePoint backups.

The following procedure requires the use of two tools, Stsadm (in WSS3) and SVMigrate (a Workflow tool). Ensure that you have them available before you begin the migrate or restore process.

Note: If you are migrating data by copying databases, do not use the following procedure. Continue to "Migrating Data by Copying Databases" later in this section.

To migrate data:

1. If you are migrating your data to a different path, create an XML file similar to the following. Open NotePad or any text editor and copy the following lines. Substituting your old and new site locations as appropriate. The old and new are indicated in bold in the example. If you are not changing the path, continue to step 2.

   <?xml version="1.0" encoding="utf-16"?>

   <MapPack xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" (see http://www.w3.org/2001/xmlschema-instance - http://www.w3.org/2001/xmlschema-instance) xmlns:xsd="http://www.w3.org/2001/XMLSchema" (see http://www.w3.org/2001/xmlschema - http://www.w3.org/2001/xmlschema)>

   <SiteToSites>

   <anyType xsi:type="SiteToSite">

   <OriginalSite>/Departments/HR</OriginalSite>

   <NewSite>/sites/sharevis/HR</NewSite>

   </anyType>

   </SiteToSites>

   </MapPack>

2. On the source site, Back up the ShareVis database using the SQL Server backup facility, or copy the data file and use another database to attach to it.
3. Run the following to back up the SharePoint data:

   stsadm -o export -url http://server/site -filename svbackup.svb
-versions 4

4. Run the following to create the Workflow mapping data:

   svmigrate -w http://server/site -f svbackup.svb

5. On the destination server, restore the ShareVis database.
6. Create the site http://newserver/site without a template applied, by using either stsadm or the Web Interface without picking a template when prompted.
7. Run the following:

   stsadm -o import -url http://server/site -filename spbackup.fwp

8. Run one of the following commands, depending on whether you are moving the path.
   • If you are moving the path, enter the following command, substituting the name of the XML file you created in step 1 (indicated in bold).

     svmigrate -r -w http://newserver/site -f svbackup.svb -m <Filename>

   • If you are not moving the path, enter:

     svmigrate -r -w http://newserver/site -f svbackup.svb