I have two different SharePoint farms, Farm1 which contains site collection site1 and Farm2 which contains site collection Site2. I have been requested to combine the two farms as the figure shows.
I need to do the combination without using stsadm -o export and stsadm -o import. (I have spent hundreds of hours applying service packs, fixing lists, correcting sp errors and I am unable to successfully export. Additionally even if export did work, when I import it breaks all of the lookup column field because SP stores them as GUIDS. So, it renders all of the sub-web collections unusable.)
Is there someway to manually move the content DB from Site1 over to Site2 and somehow attach it to Site2? This way I can have http://site2.company.com/site1