Started using toad DM relatively recently, previously was on ErWIn DM. Have created logical model initially, then using sync and convert wizard generated new physical model and SQL script for the database. Physical required some additional work like naming the foreign key attributes properly and some other. Now the question is, when I need to make changes to the logical model and propagate them down to the physical, is there a way I can compare and get the delta into the physical model or do I have to re-create physical every time I need it?
Additionally, noticed that when I generated sql script from my physical model = sql server 2012, it did not generate indexes at all for any of the foreign key attributes by default.
Does not seem optimal, why can I not see foreign key fields in logical model?
Any advise please?