This depends very much on age.
For me, my boy was 2yo when we moved into our new house. Before renovating, we brought him here and showed him his room and the house. He loved to run around in the empty house.
During reno and after reno (before move in), we brought him over a few times to look at his room (the colour, cabinets, etc).
A few days before we moved, we told him that we were going to stay in the new house and he can sleep in his room with Auntie (my maid).
We also went through house rules (no jumping on sofa, no going into kitchen, etc etc).
No problems when we moved to the new house In fact, he loves it alot