Visio Modeling and Database/Column Notes
I am using Visio for Enterprise Architects that came with the latest release of Visual Studio 2005 and am designing a new database from scratch. I have commented all tables and columns but cannot find a way to pass those values into the database during creation. This is a vital component or any database modeling tool (such as ERwin) and am curious why this seems to not be supported. I am creating the database in SQL Server 2005.
If there is a workaround, 3rd party tool, or something, please help me find a solution.
Thanks in advance.
Steve
It's pretty sad to see no one actually answered your question. It shows the kind of support we can expect for VEA: none. Probably because it will be, at some point, merged with Visual Studio 2005 Team Suite for Database Professional.
There is a feature to create comments from column notes in VEA 2005. It is turned off by default and does not seem to work anyway. Go to 'Database -> Options -> Drivers' dialog box and then click on 'Driver Misc' tab. There you'll find the folloging options in the 'SQL COMMENT ON' section.
1. do not generate
2. generate only for those with used-defined notes
3. generate only for those with used-defined notes and auto-generate when not specified.
If you get this message let me know if you got it to work.
Regards
Sebastien
Steve,
I feel the need to tell you that I am part of the ERwin development team. Here is a blog I've seen from when Visual Studio for Database Professionals announced their RTM Date.
This has been a fantastic day! Today at the SQL PASS conference, we publicly announced our RTM
( Release To Manufacturing ) date, and have announced additional
content to the MSF Agile and MSF CMMI process guidance templates. CA
also announced an integration with it AllFusion ERwin Data Modeler product with DBPro, which is also great stuff for you data modelers out there!
Here is a link our press release.
-Sean
