Description:
I would be nice to have the option (through settings) to change the default behavior of the update type during synching tables that are on the model and not on the database (source).
Currently when synching a model, the update type defaults to "Use Model" for tables not on he EER model but that are on the source(database).
This current default setting (use model) has the potential of wiping the entire database, if the user does not expand the schemata to check or is not careful. Additionally a user wastes time changing the update type to "ignore" on databases with many tables not related to the current design model.
In my case, I have a development database with over 600 tables for several modules. I design new models as necesary for new modules within the same database. For example, if I'm developing a new module of 10 tables on a database of 600 tables, every time I synch my model in MySQL Workbench, I have to manually set the update type to "ignore" for the ramaining tables not on the EER model.
How to repeat:
0. Create a database outside of Workbench and create two random tables (this simulates cases of users with existing databases, prior to using Workbench)
1. create a EER model and 1 random table to the EER design
2. click on Database menu
3. Click on Synchronize Model
4. click on Continue from the "set parameters for connection a DBMS" screen
5. click on Continue from the "Connect to DBMS and Fetch Information" screen
6. Select the appropriate Schemata and click Continue
7. Click Continue from the "Retrieve Object Information" screen
8. Expand the model by clicking on the Right-arrow
9. Notice how those tables that are on the source but not on the model are marked as "N/A" on the model and the update is set to "use model"
10. I'm recommending that the update for these cases should be set to ignore by default or allow the user to change through the settings to either "update model", "Ignore" or "Update Source"
Suggested fix:
1. Set the default "update" to ignore when there are tables on the source that are not part of the current EER model and/or
2. Add an option on the settings/preferences that would allow the user to change the "update" from "update model", "Ignore" or "Update Source"
