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