Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to export erwin's attribute name to sql server

Status
Not open for further replies.

SonicChen

Programmer
Feb 14, 2004
62
CN
i use "erwin" to design tables and their relationship for "sql server".
all table's column has it's attribute name which in fact is a column's description.
so i need to export these attribute name into column's description in sql server 2000.
how can i do?
any response is appriciated.


way to gold shines more than gold
 
Probably belongs in the ERwin forum, but here you go. Change the drop down box from Logical to Physical. From the top menu, choose DAtabase and select your database (SQL Server) and version. From the top menus, select Tools, Forward Engineer/Schema Generation.

Choose the options you want (you may need to fool around with this a few times to get what you want).

Then push the Generate button to build, or the Report button to build a script.


-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright
 
sorry, i havn't descript my problem exactly.
i'm chinese user to erwin, so we often store the chinese name in logical view.
the target i want is to generate the logical information into description in sql server's table column.
so i dont' know whether erwin has this function.
thanks a lot.

way to gold shines more than gold
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top