it really depends on the individual puppy whether they sleep thrugh the night or not.
when my ellie was just a little 8 week old puppy, she slept through the night, between 7 and 9 hours. i had her in bed with me, so i'd wake up whenever she had to go.
quigley i got much older, at 12 weeks, and he slept in a (closed) crate for the first year and a half, mainly because of the cats. he also never had to get up during the night. once in a while he'd wake up an hour earlier than usual and have to go outside.
individual preferences differ, but 'm not a big fan at all of training puppies to pee on pee pads or papers and then having to retrain them to go outside.