0002 Users

0002 Users

Migration Path

• PON_APP-USERS -> Users, LoginUser, OrganizationApplication
• PON_APP_GROUPS -> Groups
• PON_APP_USER_GROUPS -> UserGroup

Data Considerations

• Duplicates
  • GROUPNAME -> GROUPNAME_x
• Null Data Replacement
  • PON_APP_USERS_GD, EMAIL

Other Notes

• Duplicate email addresses are not allowed in BrM 7.x. Duplicates will be modified to an “@mayvue.com” address in the TRANSFORMED database before migration.
• LoginUsers and OrganizationApplication are security related tables.
• All groups migrate as IsStandard = 0, regardless of their setting in BrM 6.7.1.
• There are two insert statements for UserGroup, as the Default group changed in BrM 7.x and there should not be 2 Default groups in BrM 7.x. BrM 6.7.1 default users will migrate into the new BrM 7.x default group with the second insert.