But now with the new HDD camera the Pinnace 8 version is outdated and won't recognize the file....
You've already identified the problem. The new Sony uses a codec that the Pinnacle system won't recognize. The Sony probably uses some form of MPEG codec and you need to use a software tool to transcode this footage into some form of MJPEG for the Pinnacle system. This can be done, but you might have to invest a bit of money for this tool.
I can't be more specific since I don't own either of these systems, but I'd Google the following search terms. "codec transcoders", "mpeg to mjpeg". Try the forums at Creative Cow.
The only other thing you can do is use the analog output from the Sony and use the Pinnacle system to import and digitize the analog signal. (if it can do this)