1) There's nothing in there now to convert the ratings.
It looks like the w3t_Ratings.R_Rater column needs to be converted.
Also, the w3t_Ratings.R_What column needs to be converted if it's a username (w3t_Ratings.R_Type == 'u'), rather than a post number (w3t_Ratings.R_Type == 't').
In addition, w3t_Posts.B_LastEditBy was left out.
Thanks for the feedback. I'll make a note to add these in. Please let me know if you find anything else missing.
2) It should handle case-conversions correctly. That was one thing that I did test. The lowercase/uppercase stuff had to do with a bug in an earlier version - if the old and new names differed only in case, the user got deleted. The earlier posts in this thread discuss that.
Last edited by Dave_L; 07/06/2002 9:50 PM.