The only difference is "de donde es usted?" is more formal. You use this sentence when you are trying to know more of a person and there is no confidence between you and that person. Now, in a relaxed situation, you can ask "de donde eres?". In this case, is less formal, and it's used between colleagues, friends.