They all look like I need to manually create all the tables and columns and draw their relationships out by handĪny decent data modelling tool supports reverse engineer a physical data model from an existing schema. ![]() Note: TOAD is not an Oracle product, it is owned and developed by Quest. Our organization only has Oracle's base version not sure.) Any thoughts on the options I have?īundle: Toad for Oracle Base (64-bit), Add-Ons: Our organization only has Oracle's base version unfortunately (I think the premium bundle has data mapper included in it maybe. Could I somehow automate the table, column, and relationship creation process? I'm hoping to minimize as much manual labor as possible and am wondering if using TOAD data modeler would help since I'm using TOAD for Oracle anyways. With TOAD for Oracle, I'm able to see all columns in our tables easily, so I started looking at different database mapping tools (ER/ONE, DDM, Astah) but they all look like I need to manually create all the tables and columns and draw their relationships out by hand. Since our organization has been around for a number of decades, its database is massive. I need to start a long-term project in mapping out data tables so that we can get a high-level view of what information we store in our Oracle database and how the tables are linked to each other.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |