I have a question on DataNAV (which I’ve found to be most useful):
If I have a model with DataNAV links and then subsquently the database is migrated to a new schema, e.g. new fields are added, removed, changed, primary key fields changed etc., then is there a way to adapt the model to the new schema?
At the moment, after a migration, the DataNAV pane does not reflect the new schema and it looks to me like I’d need to clear all the DataNAV links, set up the data source again, and re-link the categories and items. Obviously I’d like to avoid this if possible, but I get the feeling this is a fairly tricky problem to solve.
Thanks – the changes show up in the data source dialogs but don’t make it through to the model. At least, not in my set-up: I import only one table then this links through to another via a foreign key – if I add a field to the linked table then this does not show up via the join, but if I add the table at the top level then it does. It looks like setting up the data source again is the answer at the moment.
Hi – Thanks for posting. It has been my experience that if you right click on the data source and edit… then walk through the screens by clicking next… the database should be reaccessed and any schema changes updated.
I know this has worked with minor changes in the DB (adding new columns etc) but not sure how things would go if things radically change. In that case might be good to set up the data source again.