can i have Xbox live gold on 2 consoles?

If Live Gold is on your Home Xbox account then you will need to purchase a new subscription.

it is on my account, but i do not play on it. Can i change my profile so it becomes my sons ? he is not bothered about keeping his gamer tag, he is only 8 years old.

what you can do in this situation is to turn off auto renew on your Live Gold then when it runs out get Gold on your Son's account. then get your Son to sign in on your Daughter's Xbox and make that his Home Xbox.

until the Gold runs out you can sign into your account on your Daughter's Xbox and as long as you are signed in, she will have access to Gold and all the purchased games.

you can set your account to automatically sign in on your Daughter's Xbox then set it to require a passkey to make purchases.

Hello Dawn Miller-Abbiss,

Thank you for keeping us updated. It is not possible to move saved data, games and downloadable content from one account to another. You can have your son use the Xbox profile on your account, but he will not have access to any games that are purchased
on his account or his saved data. You can only share your Xbox Live Gold subscription on one console at a time. The best option in this scenario is to place Xbox Live Gold on your son or daughter's account instead of yours, and have your son or daughter's
account
share the subscription to one of the consoles. We hope this helps!

it is on my account, but i do not play on it. Can i change my profile so it becomes my sons ? he is not bothered about keeping his gamer tag, he is only 8 years old.

It is not necessary, with a family account they can share the services of gold and gamepass, so you do not have to spend more

I leave these links with information

https://support.xbox.com/es-MX/my-account/microsoft-account/microsoft-account-family-benefits

https://support.microsoft.com/es-es/help/12417/microsoft-account-add-members-to-family