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.
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.