For example, backup the groups tables:
select * into bkgeminiglobalgroups from geminiglobalgroups
select * into bkgeminiglobalgroupmembership from geminiglobalgroupmembership
select * into bkgeminiprojectgroups from geminiprojectgroups
select * into bkgeminiprojectgroupmembership from geminiprojectgroupmembership
After the upgrade truncate those tables:
delete from geminiglobalgroupmembership
delete from geminiglobalgroups
delete from geminiprojectgroupmembership
delete from geminiprojectgroups
Insert the data:
SET IDENTITYINSERT geminiglobalgroups ON
INSERT INTO geminiglobalgroups(globalgroupid, globalgroupname, globalgroupdesc, globalgroupsystem)
SELECT globalgroupid, globalgroupname, globalgroupdesc, globalgroupsystem FROM bkgeminiglobalgroups
SET IDENTITYINSERT geminiglobalgroups OFF
SET IDENTITYINSERT geminiprojectgroups ON
INSERT INTO geminiprojectgroups(projectgroupid, projectgroupname, projectgroupdesc)
SELECT projectgroupid, projectgroupname, projectgroupdesc FROM bkgeminiprojectgroups
SET IDENTITYINSERT geminiprojectgroups OFF
INSERT INTO geminiglobalgroupmembership(globalgroupid, userid)
SELECT globalgroupid, userid FROM bkgeminiglobalgroupmembership
INSERT INTO geminiprojectgroupmembership(projectgroupid, projectid, userid)
SELECT projectgroupid, projectid, userid FROM bkgeminiprojectgroupmembership
