I was concerned about the pain, but if you use plenty of lubrication, its not that bad. It didn't spoil the night at all. It took us a couple of times to really get things going (we both had no idea what we were doing), but once we did it was good. There were some times when there was pain but you get through it. Its not excruciating, merely uncomfortable.
I'm VERY sensitive to pain town there, so for me to say that it wasn't that bad means that it prolly wasn't that bad.
I would recomend going to the gynecologist before your wedding night (not like the day before but somtime close to time). If you can make it through that you can make it through anything. *shudders*