diff-generatesql

This plugin can help you quickly get the difference in the table structure between the two databases, thereby reducing communication time with developers

It can run in any product that uses the plug-in Database, such as IntelliJ IDEA, DataGrip

steps

1. click on Database
2. Choose two My SQL databases (If not, you need to add the My SQL data source first)
3. right click "Diff-GenerateSql"
4. Select which database is the source and which database is the target, and click OK
5. Wait a moment (a few seconds)
6. Get the difference between the source and target databases,can be executed directly in the database

PS: At this stage,Only Supports MYSQL Database

Installation

• Using IDE built-in plugin system:

  Settings/Preferences > Plugins > Marketplace > Search for "diff-generatesql" > Install Plugin

• Manually:

  Download the latest release and install it manually using Settings/Preferences > Plugins > ⚙️ > Install plugin from disk...

---

Plugin based on the IntelliJ Platform Plugin Template.