can I sync mysql schemas with datagrid Follow
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?
Please sign in to leave a comment.
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.