You could try using data updater in xrm toolbox. Have you used that tool before?
Test whatever you’re going to do first in a non production environment. It seems to me that the data updater can skip some business logic sometimes and you could mess your data up.