First a couple of quick notes: You can synchronize your model or your database and generate an ALTER script When you import one or more objects from a data dictionary to your model, it ties that model to that particular database So the challenge presnted is: who do I compare my model against a different [...]
data modeling
How to Quickly Set Classification Types for Tables in Oracle SQL Developer Data Modeler
Your relational model may for a data warehouse or star schema where you need to define a table as being a dimension or fact. Or maybe you’re like my friend who asked me this question last night: If I’m looking at about 90 Dimension tables which all have the name prefaced by “Dim” how can [...]
Won’t You Be My Neighbor? Selecting Related Objects in Oracle SQL Developer Data Modeler
I loved Fred Rogers. He helped raise me. Nicest guy ever? So what does he have to do with Oracle SQL Developer Data Modeler? One word, ‘neighbors.’ I got a good question from a new user yesterday: Is there a quick way to add all the tables (to a subview) directly related to a specific [...]
Oracle SQL Developer Data Modeler v3.3 is Now Available
Oracle’s free data modeling solution, Oracle SQL Developer Data Modeler, has been updated with the release of version 3.3. I’ve already previewed a few of the new features here, and I’ll continue to talk more about the latest and greatest features. You can see the full list of new features and download the tool on [...]
How to Create or Open a Data Model in Oracle SQL Developer
The Oracle SQL Developer family currently has two ‘SQL Developer’ branded products: Oracle SQL Developer Oracle SQL Developer Data Modeler Oracle SQL Developer is the database IDE and Oracle SQL Developer Data Modeler is our dedicated data modeling solution. Where it gets interesting is that the entire Data Modeler product also runs inside of SQL [...]

Twitter
RSS
GooglePlus
Facebook