Scruffy-SJB

Hi,

If I try to copy a database table in an Visio EA diagram and that table has columns that are user defined types, I end up after the copy with duplicate user defined types defined. Same name, same definition......

Anyone know a way around this

Thanks, Simon




Re: Visual Studio Team System - Architecture & Design Copy a Table that has User Defined Types

Ross Grayum MSFT

Hi Simon, I've tried out the scenario you've described, and found that you are running into a bug. As you've indicated, when you copy a table that includes user defined types, the user defined types are duplicated. However, note that both tables in your model will be referencing the orginal copy, and the duplicate copy is unreferenced. To work around the bug, after copying the table, choose "Database | User Defined Types...". The User Defined Types dialog will list both the orginal and the duplicate copies of your type. To fix the problem, delete the duplicate copy. You wont be able to tell visually which is the duplicate, so you'll just have to pick one and click the "Remove" button. If you happen to pick the orginal, you'll get a message box saying "This type is used by 2 object(s). Are you sure you want to remove it " Choose No, and try removing the other copy. When you remove the duplicate copy, it wont be referenced by your model and it will simply be removed.

-Ross





Re: Visual Studio Team System - Architecture & Design Copy a Table that has User Defined Types

Esther Fan MSFT

Hi Simon,

Can you report this issue through Microsoft Connect Please also include Ross's workaround. That way, the team can connect this issue with a customer. Please use the following instructions except replace "Team Edition for Software Architects" with "Visio for Enterprise Architects". Thanks!