Let’s say you have a large number of people with surnames: of Burgundy, di Borgogna and de Bourgogne (sometimes more than one, with primary and alt names and sometimes different casing) and as an end result you wanted
Primary name: of Burgundy
Alt name: de Bourgogne
Ensuring correct casing, keeping existing alt names but not creating duplicates.
How would you do it?
I’m not at my RM computer but I don’t think there is a way to that on a batch basis within RM so it would have to be Edit Person one at a time. Because it’s a large number of people and because I know a little about the RM database structure and SQLite, I would do it with SQL queries.
Modesty detected. 
@DanielGarcia if Tom’s recommending SQL queries, you can be sure that’s the most reliable way.
You might create a gedcom, then do edits with Notepad.
I was thinking about that. You can do a lot with notepad++
I assume the export/import process will be a little lossy. If I were to export, make no changes then import into a new tree will the result be identical to what I started with?
It depends on the data types you have in your database. Some are lost. See
Due to so many spelling variations of some names I made a special fact “Surname Variations”. Then I add all the spellings in lower case and the present spelling in capitals. (ie: Surname Variant: Falk,Falck,Faulk,Folk,FALCKE) Lot less typing when adding others. Love to hear your ideas