Model refresh not detecting changes   

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.

date: 29 Nov 2005 12:46:03 -0800   author:   Brent

Re: Model refresh not detecting changes   

Sorry, This should be Visio 2002, not 2000.
Brent wrote:
> 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.

date: 29 Nov 2005 13:24:54 -0800   author:   Brent

Re: Model refresh not detecting changes - more problems here   

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


"Brent"  wrote in message 
news:1133297163.686021.16500@o13g2000cwo.googlegroups.com...
> 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.
>

date: Sun, 1 Jan 2006 15:19:01 -0800   author:   David Carr