Membrane sweep

I'm 39w3d and have a membrane sweep booked for Wednesday morning. I'll be 40w2d. And I'm very nervous about it. My midwife has advised it can be really painful. Has anyone had one that can tell me the process/feeling/aftermath? 

:)