Migrate Database Mail to SQL Server 2019

Posted: May 26, 2020 | Author: | Filed under: Uncategorized | Leave a comment

Migrate database mail to a new SQL Server 2019 server is easy now with the help of DBATools command from your favorite machine:

Copy-DbaDbMail -Source mysql2014 -Destination mysql2019

(Use window authentication)

From your new 2019 Server, you need to refresh your account password for your profiles.

From Management>>Database Mail>>Database Mail Configuration Wizard >>Manage Database Mail accounts and profiles (second choice) >> Turn on Database Mail feature if you didn’t from the pop up window.

>> Continue to choose each Account to refresh the password value of the account to access your SMTP server (basic auth) and click finish to update the authentication information.

Finally, you can send a test email to confirm the account is working.