Best Way to Merge a Dev and Live Site to Become a Staging Site?

NOTE: XML Importer will not work for this task as the amount of data is too large.

This tool is by far the simplest solution if there’s any way you can get it to work. Is it absolutely “too large” for the importer, or just limited by file upload / PHP execution time limits? If I were doing this, I’d crank up the limits on my development environment to process a really big XML file.

If that won’t work, I’d probably guess that you have some mucking around in SQL to do. 😛