Model refresh not detecting changes

[Brent]

Hi,

I'm new to using Viso for DB modeling, so I hope I'm not missing
something simple. I've done a lot of searching on the net and while
I've found many people that have had this problem, nobody has bothered
to reply.

I'm using Viso 2000 EA and SQL server 2000, though I've had the chance
to test this on Visio 2003 Pro and it did the same thing.

After I reverse engineer the db and make changes to the db on the
server, performing a refresh on the model is very unreliable about
detecting changes. Some of the things it has missed are relationship
changes, additional table entries, and column data lengths. Also,
column descriptions changes (called notes in Visio) are never detected.
I did get the notes to detect once using a souce model, but I haven't
been able to reproduce it.

Does anyone know anything about this?

Everything I've read suggests that I don't have to use source models
for the model refresh to work, is this also true?

Thanks for any help.

 

[Brent]

Sorry, This should be Visio 2002, not 2000.

 

[David Carr]

Brent,

While I am unable to offer a solution, I would like to add that I am
experiencing problems also with updating from Visio for EA SP-2 v10.0.5110
(2002?) to SQL Server 2000.

Specifically, it seems to be having problems with a double-byte UDT -
although it would seem from MS KB article 830243
(http://support.microsoft.com/?kbid=830243) that this was something
potentially solved in Visio 2000. In my case, the SQL Server DB that I
reverse engineered ended up changing a UDT from nvarchar(100) to 'image'.
Not a good thing.

I don't know if we are dealing with the same thing, but your investigation
that your problems also exist in Visio 2003 Pro doesn't sound very
promising.

So...anyone out there that can enlighten us?

Thanks in advance,
David