views:

2086

answers:

4

I'm desperately searching for a tool allowing me to copy documents with their old versions from a SharePoint 2003 to a SharePoint 2007 site.
Do you know about any simple (and preferably free) tool which does this?

+2  A: 

We recently did a migration from SPS 2003 to MOSS 2007, and I was trying to figure out how to do this. Sadly, there didn't seem to be a great way. What I ended up doing was using a back up of my SPS 2003 content database and a MOSS 2007 VM to do a database attach upgrade of the whole SPS 2003 portal. Then, I used the content migration commands (stsadm -o export, stsadm -o import) to move the lists with all of their versions to the "real" MOSS 2007 site collection.

This page gave me the steps for doing the database migration.

There are also some nice commands you can potentially use for moving just a list here. For the record, the migration commands (e.g. gl-exportlist, gl-importlist) only work between two MOSS 2007 installations.

I definitely had to try it both with the stsadm extensions and the built-in commands a couple of times before the results were acceptable. The real key was doing the database migration to a VM to get everything into MOSS so I could use those tools.

I know this seems like a crazy amount of work, but it's the only way I found to get it done without dropping thousands of dollars for something like AvePoint's DocAve Migrators. And it really wasn't that bad.

One thing to watch out for is that, if you include user security when you do the export and import, you will get a lot of SharePoint groups and users added to your production site collection.

Abs
Thank you very much for this answer and the helpful links.
Marc
+3  A: 

This may be too late for you, but I needed to migrate from a SharePoint 2003 site to a SharePoint 2007 site and keep not only versions, but also the file metadata from all of the document libraries. The official methods of migrating or upgrading failed, so I ended up writing a tool that must run on the destination SharePoint 2007 server, but can copy from the 2003 server all lists and document libraries with metadata and version intact. It's available with source at http://sourceforge.net/projects/splistcp so feel free to use and improve it.

Michael Baltaks
Wow, this program is sorely needed. Great!
Lee
will this tool migrate user alerts that exist on a document library/list, as well as metadata (created/modified, etc.)?
Thiago Silva
I don't think so, I'd guess that user alerts are part of the MySite feature, rather than part of the list data.
Michael Baltaks
A: 

I'm actually trying to get splistcp to work, it seems perfect for my situation. However I keep getting a message saying that there was a problem accessing the destination SharePoint list web service, the request failed with HTTP Status 401 Unauthorized

I'm running the program from the command line on the destination 2007 server using the administrator's account. What am i missing? I've been working on getting it right for the past couple days but nothing's fixing it.

Have you checked that the user has permissions on the database server?
Michael Baltaks
A: 

I've got the same 401 Unauthorized response. I wonder what your config was like? Are you using the web services to accomplish this or what?

Kevin