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 issue: I create a subject area with approx. 50 tables. The problem is, they appear all over the subject area in seemingly random places. Even if I zoom out as much as possible, I can't see the entire subject area, and I need to scroll around to reach the tables. Additionally, there's an obscenely large amount of unnecessary blank space between the tables. Is there some sort of shortcut to condense all the tables in the subject area into one area (especially when there are tables that are also connected through relations)? Currently I'm moving every piece one or two at a time, but I'm hoping there's a quicker way to organize everything. Thanks in advance for your help!

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!

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, and I've had a few other coworkers try their credentials too and it didn't work. The possible error might be with the connection string,but I've tried several options, and none seem to work. These are the options I've used: jdbc:oracle:thin:@DomainName.DN.DN.com:1521:DatabaseName Of course, I didn't actually type DomainName, I changed those from the company name. This was a direct copy of the connection string that was used in Squirrel SQL for this DB. I also tried, based on a friend's suggestion: jdbc:tibcosoftwareinc:oracle://DomainName.DN.DN.com:1521;SID=DatabaseName This is the connection page that I'm using:

I have a company with a single party table containing Member ID(the primary key), Subscriber ID, Member Sequence ID, Legacy ID, and a myriad of other identifiers from random source systems. Because they all live in a single table, it's not possible to capture the full scope of a person as they could have multiple unique ID's in this table (they can be assigned a new member ID for various reasons). They can get also get changes to their subscriber ID (or any other ID) as well, with no other changes. I've tried to figure out the best way to track a person, but am a bit lost. I've created a new table, DIM_PERSON that contains some attributes. I've linked this to DIM_MEMBER via FK so a record in DIM_MEMBER can be ID Person_dim_id Member_dim_id 1 123 100 2 123 200 Which will allow you to have a one-many membership ID's to a single person. However they can change subscriber ID's without changing member_id or person_ID so i'm wondering if I need to follow the same logic and build a new DIM_SUBSCRIBER table with foreign key for the two previously mentioned tables. Would this also be the same for all other ID's and each would need a separate dimension table? The idea is to pull a single person ID and ideally see a history of all data tied to various ID's within the fact tables.

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 that is freely available. Are there any documentation or resources available that cover basic usage of ERwin and how to apply everyday database admin concepts to it?

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.
- Each department has a number, name, location, phone number, budget, and an employee who manages the department.
- Keep track of the start date of the each department manager.
b) Employees work for a department and each employee works for a designated project.
- Each employee has a number, last name, first name, address, city, phone number, rank and salary.
c) Faculty members work for a department. - Each faculty has a number, last name, first name, address, gender, birth date, area of expertise, and salary. - Each faculty works for one department but may work on several research projects.
d) Each department controls several research Projects. - Each project has a name, number, duration (in months), budget, and a primary investigator.
e) Each faculty teaches several Courses. - For each course, keep the course name, number, credit hours, type (lecture, lab, distance learning, etc.), and cost per credit hour. - A course can be offered by different faculty members. ---------- This is what I have done using ERWin 3.5 I am stuck and know that this diagram is wrong. Can someone help me with this please. Thanks in advance

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 to compare the two within ERwin itself, is there a way to convert the 2 files into a more 'standard' file type (i.e. an Excel file), and then compare the files that way? I'm coming from a programming perspective (mostly Java), and from what I've seen it wouldn't be that hard to write a program that compares 2 Excel files.

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 engineering is a viable option. We perform migrations every day, but they don't always conform to what is in Erwin, so we have a difficult time showing our end-users what is in QA and what is in PROD.

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 database "master" which is the default SQL Server, rather than being created in the database that I inserted along with the model. I cant find a way to associate my MODEL with the database I'm creating along with the model. Here is the script that ERWIN auto-generates: CREATE DATABASE Movies go ALTER DATABASE Movies SET RECOVERY FULL go CREATE SCHEMA fbd AUTHORIZATION dbo go CREATE DEFAULT Default_Value_movies_gen AS 1 go CREATE DEFAULT Default_Value_titulo_movies AS 'No title' go But it should generate automatically: CREATE DATABASE Movies go --Here should be "USE Movies",to use database that ERWIN have just created ALTER DATABASE Movies SET RECOVERY FULL go CREATE SCHEMA fbd AUTHORIZATION dbo go CREATE DEFAULT Default_Value_movies_gen AS 1 go CREATE DEFAULT Default_Value_titulo_movies AS 'No title' go Any ideas?

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?

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 *relations* inside the code. So my mission is to identify usages, relationships and make a graphic model, which I think I will use ERwin7 to do it. I stated today taking every table name and searching it in the source-code and sql metadata. I open all those files in separated instances of Notepad++ and search to see if anyone really uses that table in the source-code or in any stored procedure or function. But there are 1500+ c# files and 857 objects in the database. - Is there a better way to do that? - Is there a tool to tell me where each table is used in the code and in the database without the need of Ctrl+F for each table name or other objects I will also check? - Is ER-win a reasonable choice for doing the re-modeling?