Menu
Does anyone know how to pull a database Scheme Diff for two databases using MySQL Workbench. v5.2 states it has this feature, but I can't seem to find it. I must use MySQL Workbench.
629
2 Compare and Report Differences in Catalogs. This facility enables you to create a report detailing the differences between your MySQL Workbench model, and a live database or script. Choose Database, Compare Schemas from the main menu to run the Compare and Report Differences in Catalogs wizard.
Getting data differences of two MySQL databasesClick New.. on the product Start Page or New Data Comparison on the Standard toolbar to open New Data Comparison Wizard. Specify the needed connections to MySQL servers in the Connection fields. Select the databases you want to compare in the Database fields.
To compare database definitions. On the Tools menu, select SQL Server, and then click New Schema Comparison. Alternatively, right-click the TradeDev project in Solution Explorer, and select Schema Compare. The Schema Compare window opens, and Visual Studio automatically assigns it a name such as SqlSchemaCompare1 .
To open Schema Inspector click (i) icon that shows up on hover over schema name: or right click schema and select Schema Inspector. When Schema Inspector opens go to Columns tab. All columns are visible in a grid.
If you don't see this option directly you have to:
File and New model Database and Compare schemas.
187
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
