Note: in the queries below it is important to make a few adjustments depending on the number of rating criteria you have. The example below is for 5 criteriaIf you have defined only one set of criteria in xtdratings, then it is really easy to move your reviews. Just run the queries below in phpmyadmin. You still need to configure the criteria just like you had it in xtdratings, and also setup the categories but this is straightforward.
Transfer commentsINSERT INTO jos_jreviews_comments (id,pid,mode,created,userid,name,username,email,location,title,comments,published,ipaddress) SELECT id,pid,mode,date,userid,name,username,email,location,title,comments,published,ipaddress FROM jos_ff_review_comments
Transfer ratings
INSERT INTO jos_jreviews_ratings (reviewid,ratings,ratings_sum,ratings_qty) SELECT id,ratings,(SUBSTRING(ratings FROM 1 FOR 1)+SUBSTRING(ratings FROM 3 FOR 1)+SUBSTRING(ratings FROM 5 FOR 1)+SUBSTRING(ratings FROM 7 FOR 1)+SUBSTRING(ratings FROM 9 FOR 1)),5 FROM jos_ff_review_comments
Transfer votes
INSERT INTO jos_jreviews_votes (reviewid,yes,no) SELECT reviewid,yes,no FROM jos_ff_review_votes
