RE: SQL Dev Data Modeler
Date: Fri, 25 Apr 2014 09:09:32 -0700 (PDT)
Message-ID: <bfdb912b-deb3-43d8-9ded-d920b7976b84_at_default>
Adam,
I can help you figure those things out if you want to take it offline
HYPERLINK "mailto:Jeff.d.smith_at_oracle.com"Jeff.d.smith_at_oracle.com
I talked about much of this on my blog. For getting grants and triggers included in your scripts, you need to create and open a physical model (not just the relational.)
The versioning stuff is pretty straightforward, you’ll be using SVN. Too much to go into here for email…
Jeff
From: Adam Musch [mailto:ahmusch_at_gmail.com]
Sent: Friday, April 25, 2014 12:06 PM
To: lkemnitz_at_uwsa.edu
Cc: Oracle Freelist
Subject: Re: SQL Dev Data Modeler
I've been playing with it, and while the price is appealing, I've not figured out how to do some of the things with it I know how to do in Erwin and PowerDesigner, like automatically scripting grants and triggers, building deployments out of it, and integrating into a model repository with view-vs-update permissions. Given the size of my team (small), the cost of a couple of seats of PowerDesigner has been worth the productivity.
On Fri, Apr 25, 2014 at 10:59 AM, LeRoy Kemnitz <HYPERLINK "mailto:lkemnitz_at_uwsa.edu" \nlkemnitz_at_uwsa.edu> wrote:
We are just starting to look at and use the SQL Developer Data Modeler. We like so far.
We are going thru the online webinars and trying to learn as much as we can about this tool. Is anyone else using it? Happy with it? Run away from it?
I also found a user group named - ODTUG. Oracle Development Tools User Group. They have a conference coming up in the Fall with a few session on how to use the data modeler. Anyone have exp with this group? Worth attending?
I have also been looking for in-person training for this tool. Anyone know of an in-person training program?
LeRoy
LeRoy Kemnitz
UW System Administration
Database Administrator
780 Regent Street, #246
Madison, WI 53714
Phone: HYPERLINK "tel:%28608%29%20265%20-5775" \n(608) 265 -5775 Fax: HYPERLINK "tel:%28608%29%20265%20-%202090" \n(608) 265 - 2090
--
Adam Musch
HYPERLINK "mailto:ahmusch_at_gmail.com"ahmusch_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 25 2014 - 18:09:32 CEST