Could I create a Conceptual Data Model from Physical Data Model??
I'm trying PowerDesigner 12 and I wanted to do reverse
Is it possbile create a Conceptual Data Model from Physical?
Thanks in advance!!!
Select the Tools\Generate conceptual model menu
<Xavi> wrote in message news:firstname.lastname@example.org...
> I'm trying PowerDesigner 12 and I wanted to do reverse
> Is it possbile create a Conceptual Data Model from Physical?
> Thanks in advance!!!
...Why am I not able to select Updata Existing Physical Data Model option when I want to Generate a physical model?
I have selected my conceptual model and go to generate the physical data
model and I am not able to select the Update Existing Physical Data Model.
Any ideas why? Do I need to do something special to my logical model or
something before I can do that? At this point I only have the database in
the tool. I have not set up a repository if that matters.
If you did not create a Physical Data Model before you need to do so and
choose a DB engine. For the repository, I don't know I don't use it.
<Jodie> wrote in message
news:CF80427DA375B3310066BC3285256A72.0066BC41...Why am I not able to select Updata Existing Physical Data Model option when I want to Generate a physical model?
I do currently have a physical model. I created the physical model from my
current database and then created my conceptual data model from that. Not
that I updated my conceptual model I am not given the option to update my
I'm not sure if I understood. You created a conceptual model out of a
physical one? Why do you want to update your phys. model from the just
created conceptual one? Did you do any changes in the concept. model? No?
Then the case would be clear - no updates - no changes.
Jodie wrote in message
<2A81C1E65E503...how to extract table comments and column comments from physical data model
I try to extract the table comments and column comments
using the report tool in Power Designer. It does not allow
me to do it. Do anyone know how to extract these
I am using PD 10.0. Not sure what version you are using,
but in order to show comments in report, I go to "Table
Card" and "Table Column Card", respectively, highlight it,
then select layout from the options. When the layout
selections appear, check off comments.
> I try to extract the table comments and column comments
> using the report tool in Power Designer...Creating symbols for physical data model (PDM) classes / objects
I would like to create a diagram of our physical database.
We have created a PDM of our Oracle database, which includes
the database name, the tablespaces, the schemas, the roles,
etc. Many of these objects by default do not have symbols
and therefore can not be put on a diagram. We would like to
create one or more diagrams that shows our database and its
tablespaces, the database and the schemas, and the schemas
and their associated tablespaces. We can define all of these
dependencies in the property sheets, but it would be great
if we could define it pictorally.
Your only option f...Create logical model from physical model
I'm looking for suggestions for ways of creating a logical
model from a physical model. I know it can be done. The
bit issue that I have is Name and Code. Since we only have
a physical model, the names and codes are the same. I
thought of manually creating a conversion table, but don't
think that will work since our names are like this:
I would ideally like to find a way where the logical model
would have Provider Number as the name and PROVNUM as the
Anyone have any ideas??
This is a multi-part message in MIME format.
...PowerDesigner Conceptual modeling/Physical modeling...when to do it
We're trying to understand when in the development life cycle conceptual
modeling should take place. I'm hoping someone on this list can give me some
advice or point me to a good source for this sort of information.
The development process for us appears it should be...
1. Gather business requirements
2. Write a Functional Spec
3. Write a Technical Spec
But where in the above 4 steps do we do the DB modeling? Is conceptual in
1&2 and physical in 2&3?
We do conceptual modeling (CDM) during the Business
Requirements Gathering and Func...Create a table with two tables data
I have one access table named dados_aluno with the following fields
codigo_aluno | Nome | Turma | Cod_Professor
and one table named estagio with the fields
codigo_aluno | codigo_empresa | nome | Nome_empresa
I need to create a third table with all the data fields, but some codigo_aluno from table one don't exist in table estagio. In this case i need the field Nome_Empresa ="nada"
You want a view, not a table...? Please Mark As Answer posts that helped you."If we learn from our mistakes, I should...Display "Field Code" on Physical Data Model tables
I'm currently testing the trial version of 11.0 (not the
lattest 11.1) version of PowerDesigner.
I'm looking for a way of displaying the "Field Code" of the
table columns, instead of just the "Field Name".
Example for a Products table:
Product Code / INTEGER / <pk>
Product Description / CHAR(100) / <clean>
I want it to display:
Product Code / PROD_CODE / INTEGER / <pk>
Product Description / PROD_DESC / CHAR(100) / <clean>
That way, when I print the physical model, I can clearly see
th...How to move a row in a data table object to the top of the table? The data table is in a data set. The data is bound to a drop down list box.
I am maintaining some 2003 C#/asp.net code for a web application. In the application a table in a data set is usedto populate a drop down list box.(The drop down list box will display a list of names)
Before the data set table is bound to the list box control, blank characters are inserted at the topof the data set table. The purpose of this, is to display a blank line in the drop down list box, when the list box isinitially displayed. This code works fine. (See lines 1-14 below).
Now I have been asked to modify the source code so that instead of a blank line being inserted at to top of th...How come the relationship between tables doesn't show up in physical data model diagram
I run into an issue during using PowerDesigner When dragging
and dropping two tables in a new physical data model diagram
the relationship between these two tables does not show up.
Does anyone has any idea what's going on? Or any switch I
need turn on? Appreciate it.
Use the Menu Option Tools/Complete Links or Ctrl+F5
> Use the Menu Option Tools/Complete Links or Ctrl+F5
thanks Tom. Good man.
...How to create Table A by inserting all data from Table B?
Anyone can help me?
How to create Table A by inserting all the data from Table B?
Create table A with same structure as table B. Then:
insert into A select * from B
or if msde soesn't like * then:
insert into A select fiel1, field2,...,fieldN from BGunnar Peipman-- General Protection Fault-- Illegal Page Fault-- Not My Fault...How to Create a new Table with another Table data (replicate)
I search for a table and open it, and now I must implement an option to Replicate the table with another name(month/year) and the same Data.Looking in the web I just found about script´s but I don´t understand about data bases scripts. Plz sugestions, ideas, codes =]thx (using visual studio 2005, SQL Server)
You can use SELECT INTO to copy data to another table:
SELECT * INTO newTableName FROM oldTable
If you want to do this on the fly, you can use a stored procedure like a sample below:
CREATE PROCEDURE usp_myNewTable AS
declare @tName nvarchar(50)
decla...creating a table column that only takes data from another table.
I am trying to create a table that holds info about a user; with the usual columns for firstName, lastName, etc.... no problem creating the table or it's columns, but how can I "restrict" the values of my State column in the 'users' table so that it only accepts values from the 'states' table?ScottSEADont forget to click "Mark as Answer" on the post that helped you!This credits that member, earns you a point and mark your thread as Resolved for the sake of Future Readers.
You could create a trigger on the table or a rule?***********************Dinakar NethiLife is short. En...