First, which Sony video camcorder do you have? 8MM? Digital 8? Mini DV tape? Mini DVD+/-R?
In any case, you'll only need a DVD recorder for this task. DVD-Video combo recorders accept only the large-size VHS tapes, and cannot accept 8mm or digital tapes directly. Get a DVD recorder with both analog and a Firewire digital input just in case your camcorder happens to be a digital model.