My transition from sitting to standing took a little less than a month to get used to. I would recommend placing your desk next to a wall so you have something to lean on. It is a great way to prolong your standing time when starting the transition.
As for initial discomfort it was fairly minimal. In fact I soon began to appreciate the soreness as it allowed me to fall asleep faster as well as improving the quality of my sleep.