Moving Document Libraries from WSS 2.0 to Wss 3.0 MOSS 2007

The migration has always been an issue with MOSS as dear Microsoft never provided us with a migration tool. Well here is one way of migrating the document libraries. If you dont have the budget and time to go for a third party software this might help you.

If you have the time and money in the pot I would recommend that use METALOGIX from www.metalogix.com. After testing a number of these migration software for MOSS I have concluded that this one is the most easy to use and most comprehensive. Plus they offer great support and are quick to answer your quries unlike many others.

Ok here is the manual migration process:

Backup the databases for the sites you want to upgrade.  Restore these backups as new databases on the SQL server in your WSS 3.0 farm.  Create web applications in WSS 3.0 for the sites that you are going to upgrade.  Remove the databases that are created with these web applications through WSS 3.0 central configuration.  Now attach the WSS 2.0 databases you just restored to SQL using stsadm -o addcontentdb to the web applications you created in WSS 3.0 for the migrated sites.  This is done through the command prompt.  To do this navigate c:program filescommon filesMicrosoft sharedweb server extensions12bin and type this command filling in the appropriate information.

<strong>stsadm.exe -o addcontentdb -url http://&lt;server&gt;:&lt;port&gt; -databasename &lt;WSS v2.0 content database&gt; -databaseserver &lt;DB Server name&gt; </strong>

for example

<strong>stsadm.exe -o addcontentdb -url http://MyServer:80 -databasename WSS_V2_ContentDB -databaseserver Sample</strong>

This will do an in place upgrade of the database.

Note:  If you SQL box has instances on it you will need to specify the instance the database is in for example &lt;SQL Server Name&gt;&lt;SQL Instance Name&gt; in the &lt;DB Server name&gt; space above.