Migrate Database Mail to SQL Server 2019

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s