I don't know about your model, but other Sony Cyber-shots can be put into PTP (picture transfer protocol) mode, and you can use Cameraderie to access the camera. In that case, it doesn't matter how large the memory card is, the camera takes care of all that.
There used to be standard Sony software for the PC, so you could use this in Windows, too.