Change the Domain Name for ALL Email Addresses

Updated March 18, 2020 17:52

Organization name has changed or merged and they need to change everyone's email.

1. Take a backup or Passageways DB (PortalFX)

2. Run the following script on main Passageways (PortalFX) DB:

Colored items need to be changed per situation

UPDATE Passageways(PortalFX)

SET email = REPLACE(email, '@olddomain.com', '@newdomain.com')
WHERE email like '%@olddomain.com%'

3. Refresh Portal Cache.

4. Verify emails are changed in portal.

0 comments

Please sign in to leave a comment.