Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
other
informationbridge
office.intranets
office.misc
office.setup
office.xml
officeupdate
onenote
photodraw.discussion
powerpoint
producer
proj.standard&server
project
project.developer
project.pro_and_serve
project.server
project.vba
project2000
publisher
publisher.prepress
publisher.programming
publisher.webdesign
visio
visio.createshapes
visio.database.modeling
visio.dev.diagrams
visio.dev.shapesheet
visio.dev.vba
visio.dev.vc
visio.developer
visio.general
visio.installation
visio.printing
visio.software.modeling
visio.troubleshoot
  
 
date: Fri, 12 May 2006 15:22:01 -0700,    group: microsoft.public.visio.developer.diagrams        back       


How to disable database schema validation in Visio 2003   
Hello,

I have Visio for Enterprise Architects 2003 (build 11.4301.6568) and I am 
trying to merge 2 databases into one. Both databases has schema DDLs created 
from Visio diagrams. I merged one of the diagrams into another and now I 
cannot generate the DDL, because I am getting a lot of errors like this:

DBSCHEMA.VDX : error L2008: 'Config.ConfigGroupId' : Column has same 
conceptual name as column 'Alert.ConfigGroupId', but has a different data 
type.

The problem is that in these databases couple of columns (like 
ConfigGroupId) had the same name but different data types in these DBs, 
because they had a different data stored. It was GUID in one database and int 
(IDENTITY based ID) in the other. We have a table that stores relation 
between these IDs now and I know that it is better to rename the columns, but 
it is much-much bigger task than just merging the databases.

My question is: how can I disable database schema validation or ignore it's 
results when I generate DDL script from Visio diagram?

Sincerely, Vladimir
date: Fri, 12 May 2006 15:22:01 -0700   author:   Vladimir Lashchev Vladimir

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us