cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Zeigler <>
Subject Re: Reengineering Overwrites
Date Thu, 09 Apr 2009 19:42:10 GMT
As a follow on, it will also allow you to save the resulting SQL from  
the set of operations you choose.  I find this handy for working with  
development vs. production servers.
I'll accumulate a list of SQL changes made in development (mind you, I  
usually work from the model => db direction, so that's even  
handier :).  Those changes go into a sql "patch" file, which I can  
then apply "at once" to the production server during upgrade.


On Apr 9, 2009, at 4/92:31 PM , Weddle, Anthony wrote:

> 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: [] On Behalf  
> Of
> John Armstrong
> Sent: Thursday, 9 April 2009 5:56 p.m.
> To:
> 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.

View raw message