Questions tagged [erwin]

Use the erwin tag when referencing the erwin Data Modeler tool or any of the other tools supplied by erwin, Inc.

Filter by
Sorted by
Tagged with
0
votes
0answers
118 views

Can I migrate an Oracle Model Mart database to SQL Server

Currently we have two Model Mart repositories, 7.2 and 9.5. We only migrated the models that are currently being used, but we need to keep the old models available in case they are needed. Is there a ...
-1
votes
1answer
514 views

Logical model in workbench

I have a physical data model of db in MySQL Workbench, how i can create an a logical model of this db(like in Allfusion data modeler(ERwin))? May be Sorry for my english!
1
vote
0answers
188 views

ER Diagram with ERWin 3.5

I started my course and have been working on the ER diagram. Instructions provided are Minimum requirements and business rules for the College database a) The college is organized into Departments....
2
votes
1answer
466 views

Reorganizing a subject area in ERwin

I have a data model in ERwin (r7) that has about 1000 tables in it. I'm right now in the process of splitting it up into various different subject areas to make it a bit more manageable. Here's the ...
1
vote
1answer
1k views

How do I open an ERwin Naming Standards file (.nsm) in Excel?

I have a Naming Standards file in ERwin (.nsm format) that I want to be able to open up in Excel (for example, in order to compare 2 .nsm files). How would I be able to do that?
1
vote
1answer
71 views

Comparing the contents of 2 .nsm (naming standards) files

I have 2 naming standards files from ERwin (.nsm extension), and I want to compare them to see if they contain the same rules. Is there some sort of automated way to check this? If there isn't a way ...
1
vote
1answer
211 views

oracle DB connection - hostdef extension doesn't exist

I am trying to connect to an Oracle DB through ERwin, yet I keep getting this error message: I know that the DB exists, as my coworkers are accessing it. The Username and Password are also correct, ...
1
vote
2answers
765 views

How to find usage of each object in other objects from a database?

I am with the task of taking an old SQL Server database and identify all of it's objects and their relationships, because the one who made it did not bother to use any foreign key, he just made all ...
1
vote
2answers
2k views

Managing version control of Erwin file changes with multiple environments

What is the easiest way to manage three environments (DEV, QA and PROD) within a single Erwin file or multiple Erwin files? The Erwin file is separated by subject area, so I'm not sure reverse ...
6
votes
1answer
1k views

ERWIN create and use database

I'm trying to generate physical database from my logical model using ERWIN 7. All is well in the script that is generated automatically, there is only the problem that the model is created in the ...
2
votes
1answer
178 views

ERwin Data Modeler Support [closed]

For the sake of not asking 5,000 questions here; are there any reliable sources of information about ERwin? I have to use it for a course and I have been unable to find any website or documentation ...