The main issues that arise when working with Azure servers is their support for storage engines and other minor settings. For more details visit the post titled Limitations in Azure Database for MySQL.
Storage Engine Setup
Users that want to migrate a site to Azure can follow these steps:
- Create a backup of your Database in the event issues occur with the INNODB conversion & a revert is needed.
- Convert the tables from MyISAM to INNODB in the source site. You can execute the query below on all MyISAM tables with PhpMyAdmin or any Mysql query tool.
“ALTER TABLE table_name ENGINE=InnoDB;”
For more information you can read this post titled Converting Tables from MyISAM to InnoDB
- After the update is made be sure to fully test all areas and aspects of your site for issues.
- Create a Duplicator Package that can now be used in an Azure environment.
Same Database Setup issues listed in Duplicator Pro above