"SATA II" is one of the most miss used terms out there. edit: same with "SATA2", "SATA 2" and "SATA 2.0"
The SATA 2.0 standards added a few features over the original SATA 1.0, including 3.0 Gb/s. But a device doesn't have to have any of the big ones, including 3.0 Gb/s to claim to be "SATA 2" or "SATA II". IOW, if a device doesn't say "SATA 3.0 Gb/s", it transmits at 1.5 Gb/s, even if it says "SATA II".
One of the changes with SATA II is the max length increased from 1 meter to 2 meters. So all 2 meter cables should be SATA II, or else they're out of spec. Not that it makes a difference; AFAIK, the cable specs didn't change (besides max length). If you go longer than 2 meters, you're out of spec, period.
eSATA is a variant of SATA, with a different connector, slightly higher minimum voltage, and the longer length of 2 meters (probably due to the higher minimum voltage). Same protocol as SATA, etc. Mostly the same, and in most cases interchangeable, but not exactly.
Your Sony DVD is 1.5 Gb/s; all DVDs max SATA 1.5 Gb/s. Harddrives barely can fill 1.5 Gb/s, DVD can't even come close. I'd bet your DVD drive is SATA 1.0 (even though it could be SATA 2.0); there are no reason the manufacture to go SATA 2.0 if they have SATA 1.0 chips to use.
Note:
You might have problems if your computer chipset is SATA 1.0 and if your DVD is SATA 1.0 and if you go longer than 1 meter. (Same thing if you replace the ones with twos.) Then again, it might work fine, as with evidence of all the extention cables. But you'd be out of spec. And data loss/corruption is bad. I'm not saying "don't do it", nor "it won't work"; just be watchful if you go out of spec and make sure it works before commuting anything you can't undo, like move all your photos to disk and deleting the HD and then discover all the pics are corrupted on the DVD.