The All in One SEO is a commonly used SEO plugin with 3+ million active installs. If you want to migrate to a different SEO plugin, you should migrate the existing SEO and delete the previous plugin’s stored data.
If you are migrating to the Rank Math SEO plugin, it supports the All in One SEO plugin data migration.
The All in One SEO plugin uses the following database tables for data storage;
wp_aioseo_cache
wp_aioseo_notifications
wp_aioseo_posts
All in One SEO plugin allows you to remove ALL AIOSEO data upon plugin deletion. Make sure the “Uninstall AIOSEO” is enabled before deleting the plugin.
All in One SEO > General Settings > Advanced
You can confirm that the options and custom database tables have been deleted by checking the tables in a plugin such as WP-Optimize or hosts-provided applications such as phpMyAdmin.
Here are the two database Options that might be left over after uninstalling the All in One SEO plugin;
widget_aioseo-breadcrumb-widget
widget_aioseo-html-sitemap-widget
The above Options can be removed using a plugin such as SQL Buddy or phpMyAdmin. Dealing with data migration and cleanup is always worth doing when replacing or removing plugins, so you don’t have to deal with unused data later on.