Merging two CMS installs into one...

4 posts by 2 authors in: Forums > CMS Builder
Last Post: September 18, 2013   (RSS)

By HDLLC - September 17, 2013

for lack of a better description, I am trying to merge two CMS installs into one...

The tables all had different names, except the users, which wasn't a big deal.  I just left that table out.

I imported into the database but figured I needed to add to the schema so that they'd show in CMS Admin and could be managed.

I'm missing something in the process...  Wondered if anyone else has tried to do this?

One is a CMS Builder store install using SimpleCart while the other is a CMS Builder site we just used as a content manager.

I wanted to combine the two under one "roof".  Are there steps to doing this, or am I looking for trouble.

=^)

Thanks in advance!
--Jeff

By Jason - September 17, 2013

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

---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By Jason - September 18, 2013

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,

---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/