Database and model synchronization

[Filip]

Hi,
we have database (on SQL server 2000) and want to be able
to maintain it from within Visio (version 2003 Enterprise
Architect) or at least use Visio for documentation the
database.
I created new Database model diagram and used Reverse
Engineering to fill it with our schema. The problem is
that if DB is modified, e.g. new table/SP is added (via
sql script or SQL Enterprise Manager) and then we want to
refresh the model in Visio with Database->Model->Refresh
command, Visio does not notice the change and does not
offer to add new table/SP into model.
Is there any setting to enable recognizing of new objects
in database hidden somewhere in Visio? How I could achieve
this?

Thanks
Filip

 

[Randall Arnold]

It's my understanding what you ask requires the Autodiscovery Tools that are
no longer offered. You may have to use VBA programming to fill this need.

Randall Arnold

 

[John Saunders]

Hi,
we have database (on SQL server 2000) and want to be able
to maintain it from within Visio (version 2003 Enterprise
Architect) or at least use Visio for documentation the
database.
I created new Database model diagram and used Reverse
Engineering to fill it with our schema. The problem is
that if DB is modified, e.g. new table/SP is added (via
sql script or SQL Enterprise Manager) and then we want to
refresh the model in Visio with Database->Model->Refresh
command, Visio does not notice the change and does not
offer to add new table/SP into model.
Is there any setting to enable recognizing of new objects
in database hidden somewhere in Visio? How I could achieve
this?

I believe I read that new Stored Procedures are not picked up by a Refresh.
You will have to reverse-engineer them to get them in.