Thanks for the tip, John and Robert. However, I'm not sure that reverse capability is there in 3.0M5. If I select Migrate DB, I only get operations in the direction of the database to select. For example, I altered a table in the map and also added a table on the database; the two operations that Migrate gave me to select were to add the map change to the database and the drop the table I just created. There were no operations that provided the DB to map direction.
Maybe this functionality is not there in M5? If there was an option to migrate either way, I'm not sure it would help, since I'd want to merge changes. I'd want to keep any changes to ObjEntities that I make in Modeler and merge in any database changes (such as new tables, new columns, altered column definitions, deleted columns) to the map. Unfortunately, these kinds of operations are not uncommon here and so this would likely be a major issue for us. However, being a newbie at Cayenne, I may not fully understand the capabilities. Tony -----Original Message----- From: siber...@siberian.org [mailto:siber...@siberian.org] On Behalf Of John Armstrong Sent: Thursday, 9 April 2009 5:56 p.m. To: user@cayenne.apache.org Subject: Re: Reengineering Overwrites Under to Tools menu in the modeler you can select the 'Migrate Database Schema' command. This will diff the db against your current current map. You can then, per change, decide if you want to take the DB version, the Cayenne version or ignore. Its the best feature ever, I use it daily. This may not be what your looking for.. John- NOTICE - This message and any attached files may contain information that is confidential, legally privileged or proprietary. It is intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering the message to the intended recipient, be advised that you have received this message in error. Any dissemination, copying, use or re-transmission of this message or attachment, or the disclosure of any information therein, is strictly forbidden. BlueScope Steel Limited does not represent or guarantee that this message or attachment is free of errors, virus or interference. If you have received this message in error please notify the sender immediately and delete the message. Any views expressed in this email are not necessarily the views of BlueScope Steel Limited.