Jay, I'd think that using steel you should have enough headroom for a beam that would allow for a larger span than 8', but you'll not find a viable method to free-span 29' on a residential structure & carry the load of a second story.
You might also be able to do this with a paralam flush beam, which would carry the second floor load from the new footing, rather than in line with the existing home's foundation. In other words, the paralam is placed on the ends of the existing 2nd floor's joists (which are hung on the paralam by joist hangers), rather than underneath the joists. This would also mean you would not have an exposed header dividing the ceiling of the newly combined area. However, steel beam or flush paralam, you'll still wind up with at least 1 post to deal with, and possibly 2.