Having gone through the same process, I found the "Publlish to Provider" option in the "Server Explorer" of Visual Studio 2008 the best solution. It allows you to save the script file of your database. You may then edit that file for any errors.

It turned out in my case that there was only one error to go after, related to the core Forum extension. Other errors I got from the export or import options in the Management Studio were related to bad connections, time-outs etc.

Emptying the Events and log tables or reducing their size before you start the scripting-out process will make the rest much better manageable.

Pictures and pdf files are most likely to be found in the ~\portals\(portal id)  folder or any subfolder thereof

---

____________________________________
The one-eyed in the land of the blind.