First of you have to extract the movie from the DVDs (and Blurays) into a suitable format for archiving. For DVDs, you may already know that the encoding for the video is MPEG-2 with AC3 (also called A52 and Dolby Digital). Therefore, to preserve MPEG video quality (lossless as previously mentioned), you need to extract that MPEG-2 video and AC3 audio to a container format of your choosing: MPEG/MPG, TS or VOB. As you may have guessed, the resulting MPEG, TS or VOB files will be HUGE - upwards to several GBs each! I recommend you buy a NAS drive that is at least 4TB (Tera-Bytes) capacity. Then hook that NAS to your PC or your Gigabit Ethernet network at home.
I do not know of hand which of these are most compatible with your Sony devices. But since you will be using DLNA, my best guess would be MPEG or VOB. There are many good applications to rip your collections to the PC/NAS drive. One of these is a freebie called MPEG Streamclip ( http://www.squared5.com
) and is compatible for PC and MAC. MPEG Streamclip does many things well like merging and demuxing MPEG files. It can also trim unwanted sections of a movie clip. It's best feature, of course, is ripping unprotected DVDs into MPEG files. Make sure the DVD has no copy-protection when using with MPEG Streamclip though because it may fail to rip a Title properly. If you are not familiar with DVD hierarchy the sections are called Titles and a movie may comprise of one or many titles. Experiment first beforehand for the best format for your Sony products.
On the PC, Windows Media Server should be able to stream MPEG, TS, and VOB. I use all of these file container formats on my demo setup at work but DLNA on the Samsung, Pioneer and Sony TVs all act different as to which file they recognize and play without any artifacts or warnings. Experiment which of these container formats best support your setup. DLNA, as a protocol, is pretty limited as to which file container+video encoding+audio encoding it supported and each device that say it is "DLNA" compliant may only support a fraction of the full DLNA specification.
I have found MacX DVD Ripper Pro and Video Converter Pro (by Digi-Arty at http://www.macxdvd.com
). Contrary to the name it is also available for Windows PCs. I have bought the package for both my Mac Pro and Windows 7 Ultimate laptop at home and they are very capable of reading (even copy-protected) DVDs to MPEG files for archiving. Like you, I own over 200+ DVDs that I now store in my home NAS DLNA server. Then I use Plex (similar to DLNA) to stream the movies to the Roku XS boxes in every room in the house. Works very well in parallel to the DLNA server (Twonky Media Server, I think).
If you have to encode your MPEG archives to MPEG-4/AVC (also called H.264 and MPEG-4 Part 10) to save on drive space or lower the bit-rates or for compatibility with Windows Media Server, try Handbrake because it's the best FREE encoder for MP4 and MKV container out there - unless you know how to manipulate FFMPEG from the command line console, that is. Handbrake is based on FFMPEG and other libraries so it is very good - and did I mention, FREE?
Well, have fun ripping and encoding. Once you're in the digital video streaming Matrix - you will never go back....