F
FredH
I have a large legacy database to document (2000+ tables),
I want to programmatically set the database tables Conceptual and Physical
names,
Does anyone know how to use code to cycle through all the tables and the
column's within to set these properties programmatically?
Some background information...
I have a IBM AS400 DB2 Database that has cryptic column names but most
columns have a textual description, this is what I would like to have appear
in the Physical name field.
I have created an equivalent create table script for Microsoft SQL Server
using extended properties (Using the "Caption" name).
But my copy of Visio (Pro 2003) does not pull those in.
I have explored the possibility of gaining access to the Enterprise
Architects version, but this seems like I will not be able to gain access to
it as it's priced unrealistically, sadly I have to work with what I've got.
Any idea's appreciated...
Thanks
Fred
I want to programmatically set the database tables Conceptual and Physical
names,
Does anyone know how to use code to cycle through all the tables and the
column's within to set these properties programmatically?
Some background information...
I have a IBM AS400 DB2 Database that has cryptic column names but most
columns have a textual description, this is what I would like to have appear
in the Physical name field.
I have created an equivalent create table script for Microsoft SQL Server
using extended properties (Using the "Caption" name).
But my copy of Visio (Pro 2003) does not pull those in.
I have explored the possibility of gaining access to the Enterprise
Architects version, but this seems like I will not be able to gain access to
it as it's priced unrealistically, sadly I have to work with what I've got.
Any idea's appreciated...
Thanks
Fred