can I sync mysql schemas with datagrid

Answered

I'm currently using SQLYog to sync schema's between my test and production mysql databases.  I'd like to use DataGrip.  Is the a way to generate the SQL to sync the production mysql schema with that from my test db?

1 comment
Comment actions Permalink

Yes, you need to select both schemas with ctrl+click, then press CTRL+D (right-click -> compare), you'll get a Diff view window, and get a SQL script you need by pressing 'Apply right to left' or 'Apply left to right' buttons.

0

Please sign in to leave a comment.