thank you for your feedback.
I believe you don’t want to create one model for MySQL and Oracle databases and select MySQL or Oracle on tab General (this is not doable), but select from e.g. TestDatabase1 and TestDatabase2 (both for the same target database, let’s say Oracle 10g.).
Right now, you can use workspaces for this purposes. Let’s say you have main model. Create TestDatabase1 workspace and put there items you wish to generate for your TestDatabase1. Do the same for TestDatabase2. Then try to generate SQL script. On the last tab, you can select objects using the Workspace combo box.
- You don’t have to define database names anywhere (to fill combo box on tab General - and it should be combo box, othewise you might do typos and end up with a wrong SQL script…).
- You can simply add entity to particular workpace and make the selection faster
- You can add one entity to multiple workspaces and therefore generate SQL script with the entity for multiple databases
- You will have a clear visual overview of items that belong to particular database.
Disadvantages or using workspaces for this purpose:
Please let me know if you consider this solution to be sufficient. Thank you.
Have a nice day,