Which software is best to take footage from DVD?

Its Uk PAL DVD of my cousins last boxing match.

I know how to make the movie once i have the footage and upload to You Tube.

Is it a DVD ripper I need, and can that be done on a normal DVD drive or DVD RW drive?


 Answer to the second part is yes, any drive that can read/play the DVD will work. Not sure what the best software is though.


 I like sony vegas pro because you can just import right from the dvd and rip whatever you want plus put all kinds of cool effects in if you want.  

I like to use MPEG Video Wizard. Works great!