Just had my discogram, i wish i had not been reading forums because it psyched me out and scared me for no reason. It was not bad!!
It felt no different than the steroid injections I had. I did not do sedation for those either.
And the pain literally only lasts a few seconds until they get what they need.
It does depend on the doctor administering your test. Some can shove the dye in carelessly, others like mine are gentle.
My discogram was a breeze personally. Nothing like what i was expecting.
Slightly sore after.
Try not to be scared!