Bizarre model Refresh problems: software unusable...

D

Dmitry Duginov

Hi,

I'm having HUGE problems with Visio for EA (11.7218.8132) SP2

I prepared a model (from scratch). Performed error check, everything is
correct.
I generated the script for database creation and run it from SQL Server 2005
Management Studio, 19 tables with indexes, PKs, FKs etc. were created.
I saved the model.

No changes were made to the database structure. Four records were entered
into two tables, that's it.

On the next day I'm opening Visio model, hit "Database/Model/Refresh" and
I've got tons of different "changes":

- PKs were added...
- FKs were added...
- Columns were added to the tables
- Tables were dropped from the database
- Tables were added to the database (approximately the same list as in the
previous item - "dropped")

I.e. DOZENS of "changes" that really never happened. If I would allow VISIO
to complete this "refresh", it removes most of the tables from the diagram.

I'm completely lost. I was hoping to quickly add couple of columns, a table
and and some new keys and update the database, but now I don't see any way
to use Visio for this purpose AT ALL.

Could anyone explain in general, what's going on???

Regards,
Dmitry
 

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

Database refresh does not create foreign keys 1
Refresh Model Wizard hangs 0
Wizard for model update 0
Wizard for model update reports change of an attribute for each table 0
Refresh Update functionality 0
DB Diagram Doesn't Display Table Relationships 2
"Refresh Model" wizard creates duplicate unique indexes (SQL Serve 0
deleting an object table from diagram drops my underlying table 1

Top