I have two issues,
We would like to reverse engineer from Oracle database. Currently we have many diagrams which are not in sync with Database. At this stage we do not want to reverse engineer and merge. We want to create diagrams under separate folder. Is it possible.
2: Can we reverse engineer only one schema ?
1) Yes this is possible. I think what you're looking to do is Model -> Add new Physical model. This will go through the wizard to reverse engineer a database and place it in as a separate Physical model. You'll still have your existing Logical and Physical but it won't merge the new objects with the existing ones.
2) Yes in the reverse engineering wizard on page 2 of 5, beside Owner List, you'll click on the button and choose the one schema you want to reverse engineer.
Thank you Stanley. i will try and update you.
I was successful in particular schema where it had very less tables. But when i do for a bigger schema , it just hangs. it had about 200 tables, some tables are big also. I would like to get the diagram by schema. Since i know i can not get all schema in one diagram. Still it just hangs for hours.
Any suggestions will be appreciated.
Depending on the size of your table and the number of constraints this could take a while. The only suggestions I have is in the reverse engineering wizard to uncheck any infers and choose the Circular or Orthogonal layout. If you do any of the others, it'll take much longer too.
thank you. i was checking all infers. let me try . that means after it is reversed ,we will have to add the constraints and all manually?
the infer option will get ER/Studio to try to create any relationships that are not already there based on names, indexes, and FKs. If you leave the options unchecked then the model that gets reverse engineered will look exactly like what you have in the database with all the constraints and relationships.
Unless you know that your database doesn't have any relationships then it's usually best to leave those unchecked first so you get a better understanding of what your database actually looks like.
thank you for a good explanation. Let me try once again
I selected few tables from one schema, and trying...
BTW: it is Dimensional database
Thank you very much. That smaller set of tables without infer boxes checked worked. it created a physical model. The reason behind doing this was :
1: We have our original models with data lineages. But many are not in sync with the database. many tables have few columns added in the database but not in the model.
2: we did not prefer merge models just did not want to loose previous ones
3: Now the question is , how do we get the data lineage add to this newly created model via reverse engineering. So we can publish it on Team server for business users to look?
Thank you very much.
I think I need some clarification as to what you're trying to do. Reverse engineering itself doesn't bring back anything that would automatically populate the Visual Data Lineage tab. If you were to import via the metawizard bridges, there are some ETL tools that can be brought in and will create this for you. If you can provide some additional information, I may be able to give a better answer.
1: We have many diagrams currently in use. It has lot of entries for data lineages. But they are not in sync with Database. (columns have been added to tables directly without updating the models)
2: We got the license for Team server so we can publish the models for business users
3: Since the models are not in sync with database, management decided to reverse engineer from database, and publish them for business users.
4: But in the new models that we would get by reverse engineering will not have data lineages.
5: how do we export the data lineages that we have in our models and import back to the newly made diagram via reverse engineering. But the newly made diagram via reverse engineering has Physical model only
6: the above are the points.
Hi Stanley, thank you for helping me in the past. i have few issues on the same track.
the reason behind reverse engineering is our data models and database is not in sync. we re trying to reverse engineer and then compare and merge.
while doing one schema which has about 259 tables, i am getting the error, i followed exactly how u had suggested earlier, it worked for small schema.
I appreciate your help