Well I seemed to solve this one on my own. It was a fairly simple process, in the end, of some Search and Replace queries to the database.
I logged into phpMYAdmin to access our wordpress database and compared what a database looked like with AutoMeta installed to what a database looked like with All-in-One-SEO-Pack installed (I have multiple sites/blogs). To my surprise it was fairly similar. All the fields called "autometa" with AutoMeta installed were called "keywords" with AioSP installed. They both used the wp_postmeta table in the database, which was a good thing.
Here are the Search and Replace queries I used:
The above query searched the wp_postmeta table within the meta_key column for anything labeled autometa and changed it to keywords.
Second I updated my titles (I used SEO Title Tag with AutoMeta, but AIOSP does both) that were named "title_tag" (because of SEO Title Tag) to just "title".
Again, this searched the wp_postmeta table within the meta_key column for everything labeled "title_tag" and renames it "title".
So now the only thing left was to change the format of the values of these keyword fields. All my AutoMeta keywords were formatted as "keyword-one keyword-number-two keywordthree". Notice AutoMeta uses dashes to mean spaces between keywords and spaces to denote a new keyword. But All-in-one-SEO-Pack (AioSP) uses normal formatting like this "keyword one, keyword number two, keywordthree". So I had to do two queries to change all that and use a special WHERE command with the query.
This searched the wp_postmeta table within the meta_value column for every " "(blank space) and replaced it with a ", "(comma space) with the special condition WHERE meaning only do this to the meta_value column if the corresponding (same row) meta_key column says "keywords".
So now replace all dashes with a space in those same fields. You can see that this should be last because if you did it before #3 then it would create blank spaces to where #3 would replace with a comma space.
Again this searched the wp_postmeta table within the meta_value column and replaced all dashes "-" with a space " " but only WHERE the meta_key equals "keywords".
This is from someone whose never done an SQL query, but looked it up online. Of course I made sure to backup my database first. :) Thankfully it was all successful.
I hope this helps anyone else out there converting / migrating from the AutoMeta plugin to the superior All-in-one-SEO-Pack plugin.