"Refresh Model" wizard creates duplicate unique indexes (SQL Serve

  • Thread starter Mike from Wauwatosa
  • Start date
M

Mike from Wauwatosa

I'm using Visio 2007 to create a data model from a SQL Server 2005 database.
The database has several tables with unique indexes. When I refresh such
tables, Visio creates duplicate copies of the unique indexes, with the same
name. I can run Refresh Model again, and another copy of the unique indexes
will be created. In Refresh Model, the report says there is an extra index
with a name not showing in SQL Server (looks like Visio generated it), and it
reports the SQL Server index as not existing in Visio. Is this a known bug?
If not, I'd like to report it.

(My workaround is to manually seek out the tables with unique indexes and
remove each duplicate in turn. Then make sure I don't run Refresh Model on
these tables. It's kind of a pain.)

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC Error en Organigrama en Visio. 0
Database - Model - Errors Check 0
Problem when refreshing database model in Visio 2007 0
Database Refresh does not work 0
Error P1033 During Update Database option 0
Refresh Datadabe model does not capture FK columns 0
Forward Engineer Visio ER Diagram to SQL DDL 2
Re-Reverse Engineering from rebuilt Database 1

Top