Merging two CMS installs into one...

Hi Jeff,

In general terms, that approach looks right.  The only time you would run into trouble is when you have tables with the same names.  If all the section names are the different, that part will work.

Where I can see you running into issues is with the uploads table, as the act of importing the uploads table will wipe out all of the data in the current uploads table.  You can also run into issues with files having the same name.

I can see there being two options to tackle this issue.  If there are not a lot of records with uploads in the sections you are importing, you can simply leave the uploads table off of the import, and manually re-upload all the files you need within those records.  The other option is that if you are talking about a lot of records, you/we can create a custom import script that would take each of the uploads one at a time and "re-upload" them to your new installation.  This would avoid any num or file name collisions.  If you are interested in this option, please send an email to consulting@interactivetools.com and we can go over some options.

Hope this helps

Thanks Jason - dropped an email back...

I don't think there are any uploads that crashed...

If I add an ini file to that schema folder, it kills the cmsAdmin...  It errors out and gives the message.

Is there anything else that needs to be adjusted? 

Thanks!
--Jeff

Hi Jeff,

Thanks for the update.  I've spoken to Ross and it looks like he has all of your site details in the consulting queue, so he'll be running a few tests and we'll let you know what we find.

Please let me know if you need anything else.

Thanks,