organize my photographs

I don’t really have many print photos, aside from the digital ones I’ve had printed. I do, however, have thousands of digital photos scattered on various DVDs and CDs, which I never ever look at. So I want to get them all uploaded where I can see them all together, then go through and have some of my favorites printed to put in albums and frames. I signed up for flickr and started uploading my most recent pictures – the ones still on my computer – but I still have a looooong way to go. And then there’s putting in titles and captions, getting rid of duplicates, rotating photos, etc… etc…