magekey/module-migration-sql 2.1.1

Magento 2 Migration SQL

Type

magento2-module

License

MIT

Requires

None

Requires (dev)

None

Suggests

None

Provides

None

Conflicts

None

Replaces

None

Magento 2 Migration SQL

Developer tool helps to migrate sql scripts created based on trigger changes.

Features:

  • Create / delete triggers for table(s)
  • Push changes to sql file.

Installing the Extension

composer require magekey/module-migration-sql

Using the Extension

php bin/magento migration:trigger:create cms_block cms_page

Do insert/update/delete changes with those tables

php bin/magento migration:trigger:delete
php bin/magento migration:trigger:push [migration_name] [--module Vendor_Module]

Apply changes

php bin/magento migration:setup:upgrade

or

php bin/magento setup:upgrade

Deployment

php bin/magento maintenance:enable                  #Enable maintenance mode
php bin/magento setup:upgrade                       #Updates the Magento software
php bin/magento setup:di:compile                    #Compile dependencies
php bin/magento setup:static-content:deploy         #Deploys static view files
php bin/magento cache:flush                         #Flush cache
php bin/magento maintenance:disable                 #Disable maintenance mode

Versions tested

2.2.6