Update TYPO3 Powermail from 2.x to 5.x or a newer version

Update.sql

# Just copy all tables from plural to singular naming

create table tx_powermail_domain_model_form LIKE tx_powermail_domain_model_forms;
insert tx_powermail_domain_model_form select * from tx_powermail_domain_model_forms;

create table tx_powermail_domain_model_page LIKE tx_powermail_domain_model_pages;
insert tx_powermail_domain_model_page select * from tx_powermail_domain_model_pages;

create table tx_powermail_domain_model_field LIKE tx_powermail_domain_model_fields;
insert tx_powermail_domain_model_field select * from tx_powermail_domain_model_fields;

create table tx_powermail_domain_model_mail LIKE tx_powermail_domain_model_mails;
insert tx_powermail_domain_model_mail select * from tx_powermail_domain_model_mails;

create table tx_powermail_domain_model_answer LIKE tx_powermail_domain_model_answers;
insert tx_powermail_domain_model_answer select * from tx_powermail_domain_model_answers;

Thank you Alex for posting this!

If you have already new tables of course you need to remove them first:

drop table tx_powermail_domain_model_field;
drop table tx_powermail_domain_model_form;
drop table tx_powermail_domain_model_mail;
drop table tx_powermail_domain_model_page;

And after migration it is good to go to Install tool and use database analyzer to fix some differences.

thanks helped me alot!

drop table tx_powermail_domain_model_answer; was missing

What’s the difference to just rename the tables?

RENAME TABLE
  tx_powermail_domain_model_forms TO tx_powermail_domain_model_form,
  tx_powermail_domain_model_pages TO tx_powermail_domain_model_page,
  tx_powermail_domain_model_fields TO tx_powermail_domain_model_field,
  tx_powermail_domain_model_mails TO tx_powermail_domain_model_mail,
  tx_powermail_domain_model_answers TO tx_powermail_domain_model_answer;

What’s the difference to just rename the tables?

for me no differences, your tips work perfectly thx