INSERT INTO dog_name (
	id,
	dog_gender,
	dog_name
) SELECT 
	id,
	dogSex,
	dogName
FROM dbo.dogName;