It is not a real database, but just the images. Still great !

So you would need the regimental matricle number of sergent Roy (corresponding with the date he entered the 8e de ligne), and look up for him manually.

http://www.memoiredeshommes.sga.defense.gouv.fr/fr/article.php?laref=431&titre=aide-a-la-recherche