Colonoscopy how bad is it ? Is like sigmoidoscopy ?

im going to have colonoscopy how bad is the pain .i done sigmoidscopy before without sedation and its ok .but with colonoscopy im scared !