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.
Robert
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: siberia..iberian.org [mailto:siberian@siberian.org] On Behalf
> Of
> John Armstrong
> Sent: Thursday, 9 April 2009 5:56 p.m.
> To: use..ayenne.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.
This archive was generated by hypermail 2.0.0 : Thu Apr 09 2009 - 15:42:43 EDT