I don't use a scanner on a record collection, but I use them a lot at work.
I'd recommend a 1D (instead of 2D) bar code format. Code 128 type B is very readable on small bar codes. We mostly use DataLogic. They are very sensitive readers (but pricey!$ ~$299) and are forgiving of poor quality bar codes. Symbol Technologies (Motorola) are good. Stay away from the one's that read 1D and 2D. They're not very good on the 1D side. Look for a Symbol model that scans a very narrow beam. We've found these very good on small (narrow bar width = 3) bar codes.
Bar code generators (for free) are pretty hard to find and the Professional software is expensive. We use Brady and it's about $600. ...but it's supported and we need that.
Usually data is kept to a minimum. Serial or part number, but not paragraphs of information. Serial>>database sounds like a good plan.
Records with bar codes on them? I wouldn't have more than 20 out of 2000+
I can understand with CDs but it boggles me to think why this is in the TT forum?
Ha, I just remembered I have one of these somewhere: http://en.wikipedia.org/wiki/CueCat
It worked just fine as I recall.
Understand I do have vinyl, but only about 140 (many without barcodes),so entering those in manually is not a huge problem and going forward I can just add as I go. It's just that I want to catalog my CDs and tapes and such as well, why not? (I don't have even 100 tapes, so again manual entry is no problem there).
I experimented one night by typing in a couple of barcode numbers from CDs and it was super slick. The program went and pulled up all the info I would have entered and even put in pictures! So that's what started this quest and the fact that there is a need due to my vast collection.