I had a bone density test a few years ago. It doesn't hurt at all.
The noise the machine makes during the test was the only down side.
It's good you are getting a through testing to find an answer to your pain.