I have the MSSQL database and was able to create a master list of what users are part of which usergroup in that database, so I will be able to re-create the xf_user_group_relation table manually and then import it into mySQL via phpMyAdmin. I have noticed that in the xf_user table, the column secondary_group_ids seems to correlate to the list in the relation table.
Will I need to synchronize both of these or can I just import the relation table and then run a cron or rebuilt an index to do that?
Is there another way to do this instead of via SQL?
Thanks in advance.