Could you provide a way to update entities (Tables, Commands, etc.) in schema modeler “merging” information with the old entity?
For example, let’s assume I have Table Books in DB and 3 stored procedures Books_ins, Books_upd, Books_del associated with that entity:
when importing, actually the tables and the SPs are overwritten by the new objects (so I’m losing all the configuration I’ve done on that table).
If I import only SPs (already attached to a table), the table “lose the pointers” to that SPs and that’s quite risky, because I can miss something during import phase, breaking my app logic because of that.
Currently Schema Modeler allows to update Schema entity definition if its underlying database-level object has been changed. What exactly do you mean as ‘importing’?
You’re right, I apologize. With I mean <dragging and dropping the entity (table, view or stored procedure) from “Connections Manager” window to “Data abstract schema modeler” window>
I’m adding a screencast showing what I mean (respectively behaviour 1 and 2 of my previous post)