1. First install oracle92 and choose not to install the database (use the built-in TC template ).
2/iman0912/dbca_templates file to/Oracle/ora92/assistants/dbca/templates
3. Start Oracle's dcba to establish the Teamcenter Engineering Template database (the database's character set is zhs16gbk, and the national character set is al16utf16 ).
4 Regedit: Enter the registry, ns_lang in Oracle, and change all the values to simplified chinese_china.zhs16gbk (three in total ).
5. When installing the
password to connect to the data source, and then enter the reverse engineering interface. 4. The reverse engineering interface has user filtering, select all, deselect all, option Front, option back, filter conditions and other operational options, underneath the database has a variety of objects, such as tables, views, synonyms, users, roles, abstract data types, indexes, triggers, procedures, table space ... Wait a minute. 5. After selecting the object to reverse engineering, click OK to comp
VARCHAR (TEN) not null comment ' code encoding ',Code_chinese_name VARCHAR () Not null comment ' Chinese name ',Code_english VARCHAR (a) Comment ' English name ',parent_code_id INTEGER Comment ' Parent code ID ',Code_type VARCHAR (Comment ' code type '),Sort_no INTEGER Comment ' Code number ',create_by INTEGER comment ' record creator ',Create_date TIMESTAMP comment ' record creation time ',update_by INTEGER comment ' record update person ',Update_date TIMESTAMP comment ' record update time ',P
PowerDesigner Reverse engineering generate PDM from SQL Server databaseFirst step : open Administrative Tools in Control PanelStep Two : tap Administrative Tools and then double- Click Data Sources (ODBC) "Step three : after opening , click " add "Fourth Step : Select "SQL Server" to click " finish " Fifth Step : fill in according to your own situationDescription :Name and description can be named , The server is your database address ()Sixth S
password to connect to the data source, and then enter the reverse engineering interface. 4. The reverse engineering interface has user filtering, select all, deselect all, option Front, option back, filter conditions and other operational options, underneath the database has a variety of objects, such as tables, views, synonyms, users, roles, abstract data types, indexes, triggers, procedures, table space ... Wait a minute. 5. After selecting the object to reverse engineering, click OK to comp
Recently, a data dictionary needs to be generated to import the database structure PDM
After the import, you cannot find how to generate the document, and the help is not too detailed. I searched Google and did not find any useful documents. I 'd just like to write an article.
note the following before generating a data dictionary: powerdesigner it should be 9.5 version, at the beginning, I used 9.0 version, and I didn't find any way to g
After more than half a year of preparation, the first phase of the company's PDM system implementation will officially begin next week. The supplier has sent a strong implementation team, and the company has also formed an internal implementation team consisting of more than 20 people. Leaders also mobilized in advance. It makes it clear that there will be no rest days in the coming months, and it will continue to work overtime until the end of the ye
Tags: com click. com SQL data 5.6 BSP load SIGOne: Install the ODBC driver https://dev.mysql.com/downloads/connector/odbc/First, install the 32-bit driverSecond: Then configure the ODBC data source, Control Panel \ System and security \ Administrative Tools \ODBC data sourceThree: Open Powerdesigner16,file->reverse engineer->databaseSelect the user, select the table to be generated, view, etc.Click OK and then reverse-generate the PDM.POWERDESIGNER16 connection mysql5.6 Reverse Generation
Tags: databaseBuild MySQL database using PowerDesigner designI. Create a library script using PowerDesigner1. Design CDM (conceptual Data Model)2, choose Tools--Generate physical Data Model, select the corresponding DBMS for MySQL, generate PDM3, select database, Generate database, in the Database Generation dialog box to select the script access path and script file name4. Click OK to generate database Build library script (*.sql)There are 2 ways to execute SQL scripts:The first method:At the c
This article tools:PowerDesigner 15,Data source Oracle 11gThe first step is to create a new modelStep Two: Select the current model TestDB. Then in the menu bar Database->update model from databaseThe following window will pop up:Select or configure a data source:If there is a data source, select one directly or modify the data source configuration when it is already present.If not, click Configure to configure:Configuration such as:Finally click on test connection: Pop up the following prompt:A
:----------------trust Center----trust Center--Enable all macros "tick Trust access to the VBA project object Model"2, select "Trust Center" à "Trust Center Settings"3. Select "Macro Settings" à "Enable all macros (not recommended: Potentially dangerous code may run) (E)"and tick "Trust access to the VBA project object Model"4. Click "OK" to complete the setup, then you can use "Dbexportdoc V1.0 for MySQL" to generate the database world documentIii. Creating a World document1, double-click "Dbex
When using PowerDesigner reverse engineering to generate PDM, column annotations (columncomment) are never generated, after several hours of exploration, find a compromise method, now share the following. And hope that there is a better way to guide the master.
The month of invitation is PowerDesigner 15.2, the database is SQL Server 2008 R2
The method is as follows:
1, in the PowerDesigner interface-file-reverse engineer-database, and then select a D
Export operation: ctrl+gSet the path, other default basic can beProblems you may encounter:1.constraint Name uniqueness Error, workaround"PowerDesigner generated the same name, just change the name of the constraint."Right-click Error message selection: Automatic Correction2. Foreign key column data type divergence"Right-click Error message selection: Automatic Correction3.Existence of IndexA table should contain at least one column, one index, one key, and one reference.You can not check existe
We then write the function of the "Complaint handling" module.To start with the needs analysis, let's look at our needs:Interface Description:2.7.2 Function Description(1) Complaints handling management: Query the user submitted complaints
'******************************* **************************************** * ***** dim model 'current modelset model = activemodelif (model is nothing) thenmsgbox "there is no current model" elseif not model. iskindof (pdpdm. cls_model) thenmsgbox
Excel format
ImportCode
Using system; using system. collections. generic; using system. componentmodel; using system. data; using system. drawing; using system. LINQ; using system. text; using system. windows. forms; using system. XML. LINQ;
A MySQL table is designed in PowerDesigner of Win7. It is only found that MySQL is ready to be imported into the MySQL database.The ODBC program is not installed, and the ODBC configuration is not found in the console. This is too tricky.1. first go
%] [Default % default %][[Constraint % constname %] Check (% constraint %)]
% Colnname % indicates the column name value (which can be Chinese)
---------------------------------------------------------------------------------
Settings of powerdesigen auto-increment Columns
In PDM, view the table attributes. On the columns tab, select the entire column and view the column attributes. Click the properties icon in the upper-left corner (the one with a h
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.